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.
N2927TAltitude Aviation Services LLC · Mountain Home, IDN2927YReynolds Nathan W Jr · Piedmont, SCN2927ZDensmore Jerry L · Rapid City, SDN29282Avance Aviation LLC · Burlington, MAN29285Zrelak Patrick DBA · Apple Valley, CAN29286Wawro Christopher · East Troy, WIN29289Disarro Wayne · Wasilla, AKN2928AVista Aircraft Lc · Papillion, NEN2928HLibby Matthew P · Castle Hill, MEN2928LForristel Andrew · Temecula, CAN2928RRonin Aero Group LLC · Coconut Creek, FLN2928TWeaver Mitchell C · Howard, PAN2928XBurger Andrew J · Cincinnati, OHN2928YDiamond X LLC · Elko, NVN29292Skytime Aviation LLC · Tulsa, OKN29296Crosby Gck LLC · Fort Worth, TXN29299Svetic Russell T · Redondo Beach, CAN2929CSinnott Simonis Lyle · Girdwood, AKFirst renewal noticeN2929FSmith Lane R · Lewistown, MTN2929GTeal Derek · Worley, IDN2929XKot Ronald J · Punta Gorda, FLN292ACPatten Dale G · Lapeer, MIN292AWPalmetto Air LLC · Spartanburg, SCN292BHelo Operations LLC · Waynesville, MON292BAPic LLC · Catano, PRN292BCJjb Enterprises LLC · Saint Anthony, IDN292CAChoice Aviation LLC · Hamilton, MTN292CBPelton Project · Keizer, ORN292CDContrails Aviation LLC · Minneapolis, MNN292CPCivil Air Patrol · Maxwell Afb, ALN292CSStature Aviation LLC · Addison, TXN292DHostetler Steven J · Muscoda, WIN292EDL1 Aviation LLC · Sparks, NVN292EHGlorybe2 LLC · Saluda, SCN292EPProctor John · Rosebud, TXN292FWWallace Fred R · Wheat Ridge, CON292HPMissimer N292hp LLC · Petaluma, CAN292JEEquinoxx Flight Systems LLC · Duluth, GAN292KRv4us LLC · Manchester, MIN292LRegistered aircraftN292LAPiper 3 LLC · Chestnut Ridge, NYN292LHChristiansen Aviation LLC · Wilmington, DEN292MGGeorgia Aviation Authority · Eastman, GAN292MWGroth Greg · Cookeville, TNN292NDChristiansen Aviation LLC · Wilmington, DEN292PASkywest Leasing Inc · St George, UTN292PDBarge Photo Helicopter LLC · Rehoboth Beach, DEN292PEPhoenix East Aviation LLC · Daytona Beach, FLN292PZMalone Patrick A · Tuscumbia, ALN292RHoover Michael A · Sugarloaf, PA
Back to AD 2007-04-19 R1