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.
N272TWillis Patrick A · Eugene, ORN272TCMiller Ralph · Fleming Island, FLN272TNReed Perry L · Mooresville, NCN272VXSpence Lorne J · Saint Cloud, FLN272WYSale Reported · Eden Prairie, MNSale reported, canceledN27300Rankin Kevin J · Maryville, MON2730WKegg Larry R · Chesapeake, VAN2731MBosn Richard O · Scottsbluff, NEN2731WUsrey Curtis R · Sullivan, INN2731YGeorgia Forestry Commission · Macon, GAN2732WReik Martina · Novi, MIN2733KRegistered aircraftN2733RPatrick Barb · Farmer City, ILN2733WMclenaghan Alvin N · Phoenix, AZN27349Valley Airways Inc · Scottsbluff, NEN2736SVmc Development Inc · Sanger, TXN2736WMcnamara Jeffrey E Trustee · Riverside, CAN2738TProtac Aviation LLC · Highland, CAFirst renewal noticeN2738WMead James R · Jonesboro, ARFirst renewal noticeN2739CLge Flying Club Inc · Marietta, GAN2739RPerrong Andrew R · Huntingdon Valley, PAN2739WKessler Henry L · San Gabriel, CAN2739YEnnis Michael J · Eminence, MON273AAHammerschlag Richard S · Kamiah, IDN273BGates Hiram P · Faribault, MNN273BTN273bt Air LLC · Sweetser, INN273CCRegenald Michaud Aviation LLC · Willows, CAN273FWeimer Heidi L · Knoxville, TNN273JTros Corp · Wilmington, DEN273METopel Holdings LLC · Scottsdale, AZN273MJSmith Jeffrey W · Shreveport, LAN273RRJet Set Aircraft Inc · Van Nuys, CAN273SHSpitzer Helicopter LLC · Woodland Hills, CAN27405N27405 Holding LLC · Palm City, FLN2740RRegistration Pending · Wilmington, DERegistration pendingN2740WBakewell Keith · Independence, LAN27418Sun Aircraft Management LLC · Ormond Beach, FLN2741HEaa Aviation Foundation Inc · Oshkosh, WIN2741WEdison Robert J · Anchorage, AKN2741YCoelum LLC · Lake Mary, FLN27423Kadrmas Arnold E · Lewiston, IDN2742DLloyd Land Plane III LLC · Brighton, CON2742RCollinsworth Frederick W · Broken Arrow, OKN2742WStraub R L DBA · Stanton, TXN27447Laingkids LLC · Lewes, DEN27449Airchoice LLC · Manchester, IAN2744VHerrenkohl Robert D · Bay Point, CAN2744WWilhelm LLC · Denver, COFirst renewal noticeN27450Flying Oyster Investments II LLC · Apollo Beach, FLN2745MNfh Aviation LLC · Pikeville, KY
Back to AD 2006-10-21