AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N29SFDillon Jade E · Thornton, CON29SGMusser Richard J · Lithia, FLN29SMGarner Hannah L · Tupelo, ARN29SPPurpera Daryl G · Pride, LAN29SRAviation USA LLC · Anchorage, AKN29TAPerry Michael R · Maxwell, CAN29TEBessarab Alex · Portland, ORN29TLTml Aircraft Inc · Narrowsburg, NYN29TPBray Robert M · Lusby, MDN29TSBrady George K · Rose Hill, KSN29UAN29ny LLC · Eatontown, NJN29VRegistered aircraftN29VMDragonfly Aviation LLC · Laredo, TXN29WC29wc Inc · Malta, NYN29WHSr-22 Partners LLC · Danville, CAN29WXIngram Thomas C · Steele, ALN29WYCouloir Aviation LLC · Missoula, MTN29XCWunorse Openslae LLC · Dallas, TXN29XXMustang Aeronautics LLC · Chandler, AZN29YCAg One Aviation LLC · Villa Grove, ILN29YDPerry David · Las Vegas, NVN2ABBailey Richard T · Oregon City, ORN2AEKnestel Tony Kevin · Naples, FLN2AGCentral Air Parts Inc · Staunton, ILN2AJBlair Aviation LLC · Swamp Branch, KYFirst renewal noticeN2AMFazio Peter A · Nokomis, FLN2AWSpacecrafters Inc · Silver Springs, FLN2AXParks Dennis K · Hillsboro, ORN2BBLowry Air LLC · Tahlequah, OKN2BHNethery Cattle Company LLC · Fort Worth, TXN2BKPrevost Christopher D · Sonoma, CAN2BNJensen Paul E · Exeter, NEN2BPMiami Clipper Aviation LLC · Cutler Bay, FLN2BUAndre George Maurice Trustee · Saint Louis, MON2BYMostello Andrew · Harvard, MAN2CBBoxman LLC · Wilmington, DEN2CSBolton Geoffrey M · Groveland, CAN2CWMiller Steven D · Mccall, IDN2CZMagaw David · Sacramento, CAN2DARask Mark C · Becker, MNN2DCGottsleben John J · Tucson, AZN2DGAgostini Glenn · Tampa, FLN2DLWhitver Jeremy · Ankeny, IAN2DMWiley Post LLC · Lewes, DEN2DNHaines Matthew E · Lake Dallas, TXN2DRGustafson Dale H · Kingwood, TXN2DTBender Andrew J · Greenwood Lake, NYN2DURegistered aircraftN2DVLewis Paul A · Spring, TXN2DWSquare One Enterprises Corp · Hot Springs, AR
Back to AD 2007-04-19 R1