AD 2001-09-06
Registered aircraft · 1,218
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:2001-09-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-09-06')
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:2001-09-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-09-06') 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.
N130DWAttoyac Air LLC · Gonzales, TXN130SJAircraft Guaranty Corp Trustee · Oklahoma City, OKN131DTAerownership North American Services Inc Trustee · Wilmington, DEN131WCVoigt Aviation Inc · Park Rapids, MNN1323DEl LLC · Center, CON1327EDeguerin Dick · Houston, TXN1327KLoveland Aviation LLC · Scottsdale, AZN13291Conspec Inc · Wichita, KSN132PSU S Department Of The Interior · Boise, IDN1330GNorth Plains Honey Co LLC · Bozeman, MTN1338BSilver Creek Aviation Services · Fort Worth, TXN135GVreeland Equipment Rental LLC · Dayton, OHN135TSN135ts LLC · Lima, OHN13709Personal Wings Inc · San Diego, CAN137PFerguson Frampton Z · Furman, SCN137TSArk Aviation LLC · Moncks Corner, SCN139SAMississippi Forestry Commission · Pearl, MSN13WNRegistered aircraftN141CPCivil Air Patrol · Maxwell Afb, ALN1423WMaricopa County Sheriffs Office · Phoenix, AZN143GBDocinator Aviation LLC · Edmond, OKN143GMNby Productions · Bristow, VAN143GSPxw Services · Bristow, VAN1447LHall Daniel W · Westlake Village, CAN144GRegistration Pending · Waco, TXRegistration pendingN1458HMosle Air LLC · Far Hills, NJN1460TJlj Aviation LLC · Amarillo, TXN147GWAllen Air LLC · Creola, ALN147PASetki Air LLC · Wilmington, DEN147SASteeda Autosports Inc · Pompano Beach, FLN1488TTanana Leasing LLC · Fairbanks, AKN148DWVantage Aviation USA LLC · Tampa, FLN149DWRbf Aero · Wilmington, DEN14WLTextron Aviation Inc · Wichita, KSN15031Young J D · Plano, TXN151ZGSale Reported · Hood River, ORSale reportedN15206Megwetch Aviation LLC · Auburn, MEN152BFFlorida State Guard · Tallahassee, FLN152RFHeritage Aviation Management Ltd · Conroe, TXN153WMPollard Aviation LLC · York, MEN154HROakes Aviation LLC · Racine, WIN1558QHostettler Aviation LLC · Nashville, TNN157HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN158PAndry Holdings LLC · Missoula, MTN159KMHeritage Aviation Management Ltd · Conroe, TXN15EASwanson Blake J · Ketchum, IDN160TTStraightline Private Air LLC · Denver, CON161CSAlberco LLC · Lovell, MEN161SPCalifornia Department Of Parks And Recreation · Mcclellan, CAN1694LAccg Holdings LLC · Hyde Park, UT
Back to AD 2001-09-06