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.
N2040LLake Fun Llp · Terre Haute, INN20410Widjokongko Antonius · League City, TXN20412Atpce LLC · Wilmington, DEN20416Carl L Mccallister Inc · Wilmington, DEN20417Atpce LLC · Wilmington, DEN2041LSlik Air LLC · Topeka, KSN2041RBlair Darrell E · Trinity, NCN20422Atpce LLC · Wilmington, DEN20425Atpce LLC · Wilmington, DEN2042CDms Leasing Co LLC · Las Vegas, NVN2043Precision Aero LLC · Wilmington, DEN2043CLouisiana Community And Technical College System · New Iberia, LAN2043LBrown Dennis · Moncks Corner, SCN2043RBoltjes Thomas S · Platte, SDN20448Delta Echo Whiskey LLC · Apopka, FLN20449J2 Aero LLC · Ringgold, GAN2044DMyalik Gennady K · Campobello, SCN2044LLeitner Jay T · Hurst, TXN2044YPsalm 19:1 Aviation LLC · Annapolis, MDN2046CTexflight LLC · Beaumont, TXN2046KChristiansen Aviation LLC · Wilmington, DEN2046LRegistration Pending · Bonham, TXRegistration pendingN2046RBiser Group LLC · Huntington, WVN2047CPropp & Wings LLC · Missoula, MTN20481Lesage Robert E · Puyallup, WAN20489Lone Oak Properties LLC · Flagstaff, AZN2048LDp Network LLC · Coconut Creek, FLN20491Ross Johnathan M · Eagle River, AKN20495Pitts Dan O · Soldotna, AKN2049CPray Matthew W · Augusta, KSN2049PVan Bortel Aircraft Inc · Arlington, TXN2049RHook Sean · Garden Ridge, TXN204EAEtheredge Mark · Pell City, ALN204GACoen Brady · Wiley, CON204GLChrist Robert D · Mandeville, LAN204GSBooth William F Sr · Fredericksburg, VAN204HWNordman Marvin J · Great Bend, KSN204LCUtah State University · Logan, UTN204MATsiu LLC · Wilmington, DEN204MEArgo Aviation Inc Trustee · Wilmington, DEN204MMAvest Ltd · Hilltop Lakes, TXN204PCHestertown Aviation LLC · Monroe, GAN204PWFreeman Adam J · Long Beach, CAN204RKHermann Ron A · Sarasota, FLN204RVCollette John D · Las Vegas, NVN204SCGyure Ronald J · Fort Worth, TXN204SDOstern Mark Lynn · Rapid City, SDN204SGSquillace Daniel J · Cary, NCN204SJStuart M Davis Inc · Rice, WAN204SLBethesda Family Lp · Auburn, CA
Back to AD 2006-10-21