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.
N33LYBobo Robert A · Pullman, WAN33MDSkyhawk 172 Partners LLC · Stateline, NVN33MGTopeka Flyers Inc · Topeka, KSN33MHAkeyson Edward W · Durham, CTN33MKFessele Martin · Bridgewater, NJN33MLDaedalean Inc · Chandler, AZN33MNIts Plane Fun LLC · Sanford, FLN33MRRossum Michael M · Longwood, FLN33MUKteg LLC · Bridgeport, TXN33MY3 Wings LLC · Highland, MIN33NRLuis Antonio · Miami Springs, FLN33PCFrisbee Dennis R · Denton, TXN33PESunset Enterprises LLC · Jonesville, VAN33PHPine Creek Adventures Inc · Benton, PAN33PLMcgraw Dennis S · Oakland, TNN33PMKenmore Crew Leasing Inc Trustee · Bellingham, WAN33PSN33ps LLC · Shoemakersville, PAN33PZRygiel Jerome A · Saint Cloud, FLN33RBJudy Charles E · Lawrenceville, ILN33REChapman Richard B · Granbury, TXN33RHSteel Miles · Houston, TXN33RMTrivisonno Dominick P · Skaneateles, NYN33RNMurphey John L · Fredericksburg, VAN33RWSpencer Joseph C · Asheboro, NCN33RXM Industries Inc · Thatcher, AZN33SMoose Aviation LLC · Henderson, KYN33SAMcwherter Holdings Inc · Asheboro, NCN33SCRegistered aircraftN33SFRoseville Aviation LLC · Roxboro, NCN33SGMennella James E · Oklahoma City, OKN33SHDrl Baron LLC · San Augustine, TXN33SPCray Jaeger · Hilton Head, SCN33SSRegistration Pending · Palmdale, CARegistration pendingN33SXGonzalez Richard J · Granbury, TXFirst renewal noticeN33SYFlight Level 510 LLC · El Dorado Hills, CAN33TDLightning 35 Aviation LLC · Wilmington, DEN33TGPiper LLC · Crystal Lake, ILN33TNThree Six Bonita LLC · Georgetown, TXN33TXRegistered aircraftN33UBStubbs Thomas A · Knoxville, TNN33UT402wd Holdings LLC · Corpus Christi, TXN33VBVb313 LLC · Fort Myers, FLN33VERotermund Brett L · Fairbanks, AKN33VHRegistered aircraftN33VKEaa Aviation Foundation Inc · Oshkosh, WIN33VLPalmer Thomas W · Boulder City, NVN33VSRare Eagle Aviation LLC · Westcliffe, CON33VTTjr Aviation LLC · Orefield, PAN33VUVincennes University · Vincennes, INN33WKilcourse Jeffrey K · Tequesta, FL
Back to AD 2007-04-19 R1