AD 2000-08-22
Registered aircraft · 433
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-08-22')
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-08-22')
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-08-22') 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-08-22') 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.
N911HYHawaii County Fire Department · Hilo, HIN911MUSt Louis County Police Dept · Clayton, MON911NYSt Louis County (Mo) Police Dept · Chesterfield, MON911PGPrince Georges County · College Park, MDN911PHSt Louis County Police Department · Clayton, MON912PGPrince Georges County Police Department · College Park, MDN913PGPrince Georges County Police Dept · College Park, MDN9159FApex Heli-Support LLC · Phoenix, AZN915LYLyons Aircraft Leasing LLC · Hillsboro, ORN9204UAnduril Industries · Costa Mesa, CAN920JPKar Aviation LLC · Saltville, VAN921SDCounty Of Fresno · Fresno, CAN922SDCounty Of Fresno · Fresno, CAN926DDTurbine Flying Penguins LLC · Gardnerville, NVN9276FHeli-Flite Inc · Corona, CAN935MAlan Aviation LLC · Los Angeles, CAN93MDNew Horizons Helicopters Inc Trustee · Wilmington, DEN9413FHelicopter Minit Men Inc · Columbus, OHN9460TEvermore Aviation LLC · Wasilla, AKN951CPCity Of Cleveland · Cleveland, OHN952CPCity Of Cleveland · Cleveland, OHN952SDHeli Fly Inc Trustee · Wilmington, DEN952SFRegistration Pending · Elko, NVRegistration pendingN969MSWhirlwide Inc · Fresno, CAN969VSVertol Systems Co Inc · Destin, FLN977WFForest View Helicopters LLC · Marienville, PAN984DTSprintbach Corp · Caldwell, IDN985MVKar Aviation LLC · Saltville, VAN988DFCounty Council Of Beaufort County South Carolina · Beaufort, SCN98CPBank Of Utah Trustee · Salt Lake City, UTN991MCCharleston County Mosquito Control · North Charleston, SCN992MCCharleston County Mosquito Control · North Charleston, SCN998SHConstruction Equipment Rentals Inc · Fallbrook, CA
Back to AD 2000-08-22