AD 2000-04-01
Registered aircraft · 5,676
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:2000-04-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-01')
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:2000-04-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-04-01') 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.
N129SEBarrington Air Inc · Littleton, CON129SWRoyal Air LLC · Sarasota, FLN129WSNew Horizon Aviation Inc · Warwick, RIN12EEArizona Cloudbusters Inc · Mesa, AZN1305BTriangle Aviators LLC · Cary, NCN1306CWateractive43 LLC · Auburn, CAN1306MFreedom Aviation Inc · Lynchburg, VAN1307CHouse Of Raeford Farms Inc · Rose Hill, NCN1309GPhoenix East Aviation LLC · Daytona Beach, FLN130CPCivil Air Patrol · Maxwell Afb, ALN130DWAttoyac Air LLC · Gonzales, TXN130JAHagele Aviation LLC · Hillsboro, ORN130MEPetersens Marine Services Corp · Ridge, NYN130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKN13151F N A Aviation LLC · Wakefield, MAN1318QMustang Sally Aviation LLC · Camden, SCN131AZSuraair Holdings Inc · Wilmington, DEN131DTAerownership North American Services Inc Trustee · Wilmington, DEN131WCVoigt Aviation Inc · Park Rapids, MNN1322KCleared Into Bravo LLC · Sunnyvale, CAN1323DEl LLC · Center, CON1323KFlight Operations Aircraft LLC · Wilmington, DEN1323XMustang Sally Aviation LLC · Camden, SCN1327EDeguerin Dick · Houston, TXN1327KLoveland Aviation LLC · Scottsdale, AZN1327NGulf Coast Aviation LLC · New Orleans, LAN1327ZN1327z LLC · Palm City, FLN13291Conspec Inc · Wichita, KSN132MEPena Jairo · Catharpin, VAN132PFAbove And Beyond Aviation LLC · Austin, TXN132PSU S Department Of The Interior · Boise, IDN132VUPerformance Aircraft Sales Inc · Lincoln, NEN1330GNorth Plains Honey Co LLC · Bozeman, MTN1330NEdb Air Inc · Wilsonville, ORN1331213312 LLC · Union Gap, WAN1333EEndeavour Flight Training Inc · Opa Locka, FLN1338BSilver Creek Aviation Services · Fort Worth, TXN133CPCivil Air Patrol · Maxwell Afb, ALN133VUPerformance Aircraft Sales Inc · Lincoln, NEN1348LFlight World Inc · San Juan, PRN134BChristiansen Aviation LLC · Wilmington, DEN134DBBlue Skies27 LLC · Los Angeles, CAN134PJHelibro LLC · Red Bluff, CAN134VUPerformance Aircraft Sales Inc · Lincoln, NEN135GVreeland Equipment Rental LLC · Dayton, OHN135PJAviator Air Operations LLC · Grand Prairie, TXN135TSN135ts LLC · Lima, OHN135VUPerformance Aircraft Sales Inc · Lincoln, NEN1361MLux Aero Operations LLC · Belmont, CAN1369QAmeriflyers Of Texas Inc · Addison, TX
Back to AD 2000-04-01