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.
N38248Plane Training LLC · Rapid City, SDN3824DDavis Marc · Hilsboro, ORN3824MDraveling Larry J · Wasilla, AKFirst renewal noticeN3824RAbove All Aviation Inc · Santa Barbara, CAN3824TStevens Zane Kelly · Carthage, TNN3824WTeel Brian P · Hooper, UTN3824XHirschauer Jeffrey · Spokane, WAN3824YMclaren Richard T · Sturbridge, MAN3824ZMoore Ricky J · Milton, KYN38250Elkins John H · Lancaster, MAN38254Syracuse Flying Club Inc · Fayetteville, NYN38256Ringler Neil H · Baldwinsville, NYN3825DSelf Robert R · Tuttle, OKN3825MMckendry Scott P · Sanford, NCN3825QFischer Roger G · Torrance, CAN3825TArmstrong Aviation Services LLC · Freeport, PAN3825WKaizen Companies Inc · Boise, IDN3825XBliss Aviation LLC · Somerville, TNN3825YAtlas Mining & Mechancial Inc · Beryl, UTN38265Recipe System US Inc · Torrance, CAN38267Andy Mack Management LLC · Wilmington, DEN3826PBauries Brian W · Abilene, TXN3826WMiller Heather J · Dupo, ILN3826ZWebster William S · Eden, WYN38273Southern Aircraft Consultancy Inc Trustee · Casper, WYN38276N38276 LLC · Las Vegas, NVN3827DKendallville Flying Service Inc · Saint Joe, INN3827MFox James Douglas · Pittsburg, ILN3827QCobb Jeff B · Atlanta, GAN3827TBrauer Noah J · Covington, KYN3827YPrentice Ronald L · Winchester, CAN38282Zemetis Terence A · Meriden, CTN3828DWarner Thomas E · Beloit, OHN3828NSallustio Eric · Lake Butler, FLN3828PPupator Peter Trienko · Willow, AKN3828XAmerican Flightscope Inc · Wilmington, DEN3828YHall Edmond · Bremerton, WAN3828ZOrvin Sanden Inc · Wyndmere, NDN38291Nationwide Aviation LLC · Hudson Oaks, TXN38293L & A Bennett Second Family L P · Renton, WAN38294Aerograzmar LLC · Bloomfield, NJN3829PRalphs Thomas A · Solana Beach, CAN3829QMiller Randall J · Arlington, WAN3829TFreese Pamela L · Frederic, WIN3829XFerrari Martin · Centerville, OHN382AFState Of Louisiana · Baton Rouge, LAN382ASAero Leasing · Brookings, ORN382BTPiper Aircraft Inc · Vero Beach, FLN382CBMoncada Ramos Edwin Antonio · Lawrenceburg, KYN382CCVeenstra Timothy S · Wasilla, AK
Back to AD 2007-04-19 R1