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.
N2244QField George Jr · Overton, NVN2244TAmerican Elevator · Ruidoso, NMN2244ZGood Timothy · Waxhaw, NCN22450Red Mountain Express Care LLC · Queen Creek, AZN2245ANo Limits Aviation Group LLC · Louisville, KYN2245WDorans Aviation LLC · Yardley, PAN22467Mustang Sally Aviation LLC · Camden, SCN2247ABcs Aviation LLC · Colquitt, GAN2247BD & L Aircraft Leasing LLC · Ormond Beach, FLN2247DSky Venture Inc · Franklin, WIN2247LLonergan Michael F · Venice, FLN2247MCamp Randall · Duncan, SCN2247XElliott James F · Florence, ALN2248D2 Wings LLC · Noblesville, INN2248GClear Skies Aviation 1959 LLC · Boca Raton, FLN2248LBeck Stephan · Elko, NVN2249KGarner William B · Argyle, TXN2249PJrp Holdings LLC · Highland, CAN2249TKrause Michael B · Camarillo, CAN2249VMystere Flying Club Inc · Little Ferry, NJFirst renewal noticeN2249YBlake Bernie E · Troy, NCN224ACSellers Scott R Trustee · Racine, WIN224APCloud Catcher Aviation LLC · Great Falls, MTN224AZHeard Jesse H · Lewiston, IDN224BSHoff Brian D · Spearfish, SDFirst renewal noticeN224CMDerstine Ernest B · Pantego, NCN224DRegistration Pending · Henderson, NVRegistration pendingN224ECSweeney Edward C Jr · Parrish, FLN224GKMontana Bizjets LLC · Missoula, MTN224GNTavares Jones Timothy E · Bridgeville, DEN224JBDutchman Leasing Services LLC · Richardson, TXN224JJCox Gerald Lee · Shepherdsville, KYN224KJam Three LLC · St George, UTN224KKN224kk LLC · Newport Beach, CAN224LJJets To Helis LLC DBA · Chandler, AZN224MAAir Future Airways Corp · Miami, FLN224MGBuell Travis · Harper, TXN224PLKeeney Charles E · Ash Grove, MON224RXFlyteone Production & Maintenance LLC · Clearwater, FLN224SMMueller Terry L · Thomson, GAN224TVan Wagner Aerial Media LLC · Hollywood, FLN224TBHot Wings Aviation LLC · Indianapolis, INN224TJJennings Herschel Todd · Stone Mountain, GAN224TNPoe Edgar A · Chandler, AZN224UKNapier Timothy N · Townsend, TNN224VRConcho Aviation LLC · Sterling City, TXN224VSM&G Aircraft Management LLC · Englewood, CON224VWMeridian Aircraft LLC · Wilmington, DEN2250KKaemmerling Mirna C · White Oak, TXN2251TGardner Bryan T · Rancho Cucamonga, CA
Back to AD 2006-10-21