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.
N210SKPray Aviation Inc · Augusta, KSN210STWar Eagle Enterprises LLC · Missoula, MTN210SUOhio State University · Columbus, OHN210SXSims Stephen E · Locust Grove, GAN210WDShillieto Gordon W · Burlington Flats, NYN2110TN2110t LLC · Columbus, OHN2111ARoth David · Corrales, NMN2111CKey City Fliers · Maquoketa, IAN2111FDhs Operations LLC · Wilmington, DEN2111SSchwab Jollina Michelle · Arlington, TXN2111ZNunn Henry · Noble, OKN2112FBank Of Utah Trustee · Salt Lake City, UTN2112HAir V Inc Trustee · Wilmington, DEN2112KRocky Mountain Aircraft Services LLC · Broomfield, CON2112NV & R Aviation LLC · Georgetown, TXN2112TMarsh James M · Polkton, NCN2112ZWilson Mickey Ray · Skagway, AKN21131Emge Douglas W · Albertville, ALN2113GCarlson Lucas J · York, NEN2113KCalvin B Wiley · Summer Shade, KYN2113T10 Mile Final 33 LLC · Charleston, SCN2113WMarschke Corey A · Stevens Point, WIN21147Woolf Sarah Clark · Fresno, CAN2114CLegacy By Design LLC · Durham, CAN2114DDixie Sky Flight LLC · Deridder, LAN2114KRcs Services LLC · California, MDN2114QJet Air Inc · Iowa City, IAN2114RPower Michael L · Bend, ORN2114SCochise Community College · Douglas, AZN2114TPulka Michael R · Yardley, PAN2114WHippensteel Michael J · Newville, PAN2114ZEagle & Associates LLC · Lake City, FLN2115BMisner Gear K · Phoenix, AZN2115KLiprie Randal C · Lake Charles, LAN2115MRedman Company LLC · Troy, MIN2115UDengler Steven G · Lopez Island, WAN2116UBreaux Family Investments LLC · Alexander City, ALN2116ZBush Stanley D · Anthony, NMN21177Valiair Lc Trustee · Casper, WYN2117HEarl Nathan E · Noblesville, INN2117TCruce Aviation LLC · Marquette Heights, ILN2117USouthern Aircraft Consultancy Inc Trustee · Casper, WYN21183Bkr LLC · Jacksonville, FLN2118ASouth Dakota Highway Patrol · Pierre, SDN2118JLamb Chops Inc · Bakersfield, CAN2118LIasco Flight Training Inc · Redding, CAN2118NBillberry Daniel · Chula Vista, CAN2118WWegner John B · Preston, MDN2118YS&G Enterprise Inc · Owensville, INN21198Jackie Hood Farms LLC · Moulton, AL
Back to AD 2006-10-21