AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1197GFlying Tigers Flight School Ltd · Houston, TXN1197QSmoke Seen LLC · Farmingdale, NYN1197ZAegis Protective Services LLC · Broken Bow, OKN1198UFico Dennis · East Northport, NYN1198XDiscover Aviation Center LLC · Elyria, OHN11999Euroaviation Inc Trustee · KematenN1199DSpacely Space Sprockets LLC · Aurora, ORN1199EThibodeaux Brian A · Eagle River, AKN1199HWingsleasing LLC · Wichita, KSN119AVFour Mac Air LLC · San Diego, CAFirst renewal noticeN119AZTuozzolo Thomas J · Lakewood Ranch, FLN119BCW D Investments LLC · Sammamish, WAN119BSDrinkall Jamey L · Nampa, IDN119BTDelaware US Investments LLC · Corpus Christi, TXN119CMSahm Ralph K · Santa Clara, CAN119DBWalker John D · Neosho, MOFirst renewal noticeN119EAce Aeromotive Inc · Miami, FLN119GMLai LLC · Flowood, MSN119GSDall James R Jr · Hayes, VAN119JMEverything Pitts LLC · Queen Creek, AZN119KRc Stone LLC · Willacoochee, GAN119KSKent State University · Stow, OHN119LSMarsair LLC · Franklin, WIN119PWMeyer Peter W · Stevensville, MDN119RJHunter Briard L · Detroit Lakes, MNN119SJetkinect LLC · Henderson, NVN119STSandberg Brian · Lancaster, CAN119TBFlint Kelley C · Tulsa, OKN119VKKhrupin Vadim V · Sacramento, CAN119WKOntop Airops LLC · Maumee, OHN119WPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN11AHHilltop Aviation LLC · Dauphin, PAN11BHHarbold Norris Brown Jr · Lake Wylie, SCN11BWQuonset Aviation LLC · North Kingstown, RIN11CASky Dragon LLC · Atlanta, GAN11CDTravelaire Service Inc · Pueblo, CON11CGComanche 260b-N11cg · Pomeroy, WAN11CKEagle Aeroworks LLC · Chesterfield, MON11CVStoots Christa M · Tucson, AZN11DLLemieux Theodore R · Montgomery, NYN11DWCalnevaz Corp · Sheridan, WYN11EWFrank Jerry W · Vonore, TNN11FLBell Christopher K · Ashley, OHN11GACrosswind Leasing LLC · Prescott, AZN11GNHaley James M Trustee · Edmond, OKN11HGonzalez Richard J · Granbury, TXN11HAVintage Aero Inc · Brandon, FLN11HCConway Philip J · Chatfield, MNN11HUC5 Holding LLC · San Juan, PRN11HWSky West Aviation Inc Trustee · Albuquerque, NM
Back to AD 2006-10-21