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.
N242JMLitsky Steven H · University Place, WAN242JWAviation Leasing Co LLC · Ooltewah, TNN242KFTio Pedro P · Miami, FLN242KMPlane Care Inc · Weston, FLN242LHMatthews Micheal S · Reno, NVN242MEMike Echo Ventures LLC · Coral Gables, FLN242MGHelo 1 LLC · Anchorage, AKN242MPWestwood Dave · Red Lodge, MTN242MZBechara Nizar E · Columbia, MDN242NPBa Flight Experience LLC · Margate, FLN242PHoeme Eric L · Leoti, KSN242RBContinental Aerospace Technologies Inc · Mobile, ALN242RKBas Part Sales LLC · Greeley, CON242RSPape Brandon M · Mc Gregor, TXN242RVSearle Ronald Q · Franktown, CON242SBMartin Thomas R · Roseville, MNN242SP242sp LLC · Blaine, MNN242TC182 Flight Corp · Bronx, NYN242TWTw Airplane LLC · San Antonio, TXN242USilver Creek Aviation Services · Fort Worth, TXN242YAerospace Development Group Inc · Trinity, FLN24301Pacific Coast Cycle Corp · Kings Beach, CAN2430YBuckman Arnold H Trustee · Spring Valley, ILN24318Milo Technologies LLC · Woodstock, GAN2431GGulf Coast Helicopters Inc · Pearland, TXN2431QWade Consulting LLC · Aviston, ILN2431SDavis Girls LLC · San Jose, CAN24334Sorbi Aviation Inc · El Cajon, CAN24337Dunn Craig M · Sarasota, FLN2433EElco Electric · Bangor, MEN2433SN2433s LLC · Manassas, VAN2433UEddleman David Baggett · Mclean, VAN24342Loma Aviation LLC · San Diego, CAN2434MSky'S The Limit Flying Club Inc · Findlay, OHN2434YRegistration Pending · Cedar Falls, IARegistration pendingN24350Aero Equities LLC · Ventura, CAN2435CAzure Skies LLC · Bloomington, INN2435MBrolan Aviation LLC · Kansas City, MON2436MVenture Aviation Inc · Arlington, MAN2436NThunderbird Aviation · Bloomington, MNN2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeN24372Curns James R · New London, WIN24376C R Transport Inc · Wilmington, DEN2437MRock Full Gospel Church · Parkersburg, WVN24389Way Of The Lord LLC · London, KYN2438ERainier Flight Service LLC · Renton, WAN2438RSpeed Hunter Aviation LLC · Franklin, OHN2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeN2439BVan Bortel Aircraft Inc · Arlington, TXN2439C206 Aircraft Leasing Co Inc · Marathon, FL
Back to AD 2006-10-21