AD 72-03-03 R3
Registered aircraft · 17,028
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N8633JHise Mark J · Nolensville, TNN8633SUhler John A · Rimrock, AZN8634GRegistration Pending · Princeton, MARegistration pendingN8634JDestination 55 LLC · Cave Springs, ARN8634SHersom Jeffrey T · Helena, MTN8635GSmith Andrew W · Willow, AKN8635SWood Timothy M · Jefferson, MEN8635ZLipper Stephen W · Griffin, GAFirst renewal noticeN8636UMls Holdings · Newbury Park, CAN8637GReichenbach Louis · Northville, MIN8638SLyon Ronald C · Berlin, VTN8638ULittle Kenneth C · Driggs, IDN8638ZEichman David A · Topeka, KSN8639GRegistered aircraftN8640GRoss Peter W · Lufkin, TXN8640USunnyside Aviation Pllc · Theodosia, MON8641SSimmons Anthony C Jr · Allendale, SCN8641UJohnson Jay A · Lisbon, IAN8643ZVitatoe Industries Inc · Chillicothe, OHN8644GMelin Jeff C · Kenmare, NDN8644SRiggan Charles H · Oxford, NCN8644UFung Tak C · Ridge, NYN8644ZMasters Mission · Nenana, AKN8646SFoster Brian E · Bartley, NEN8648GAugust Aero LLC · Kalispell, MTN8648SSnodgrass Gavin I · Belle, MON8649GMullins Steve F · Belews Creek, NCN8649SGuffey Edward B · Bessemer City, NCN864TGTouch N Go Aeroworks LLC · Greenville, SCN8650SGrant Clinton A Trustee · Portage Des Sioux, MON8650ZBarry Russell L · Fort Mohave, AZN8652SKindel Michael W · Bismarck, NDN8653GArmstrong John K · Lovington, NMN8653UCurtis Heather · Fairbanks, AKN8654UThompson George C · Rogersville, ALN8656JMeyer Eric Trustee · Moscow, IDN8657GClayton Patrick D · Hazen, ARN8657JCompany Air LLC · Bermuda Dunes, CAN8657URidley Timothy A · Uniontown, PAN8658GWestrum Sean Ross · Norwalk, IAN8658SBird Jared N · Mission, TXN8659GCoker Jason John · Caribou, MEN8659JThomas Chase D · White Oak, TXN8659SRegistration Pending · Davenport, FLRegistration pendingN865PHPhe Inc · Roseville, CAN8660SDepaula Saulo C T · Princeton, MAN8660USage Point Ventures LLC · New Harmony, UTN8661JSaa Enrique A · Lubbock, TXN8661UBaird Adam D · Salisbury, NCN8662SRegistration Pending · Lynchburg, VARegistration pending
Back to AD 72-03-03 R3