AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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.
N7204QTexas Air Rangers LLC · Mckinney, TXN7204WKlein Kaylin · Stillwater, OKN7205GJones Keith · Tucson, AZN7205PL F Rothschild & Company Inc · Shingle Springs, CANon-citizen corporation, flight hours not reportedN7205QN7205q LLC · Titusville, FLN7206CDwyer Benjamin J · Colorado Springs, CON7206FVoyage Capital Ventures LLC · Knightdale, NCN7206LWilliams Harry D III · Summerland Key, FLN7206QN7206q LLC · Myrtle Beach, SCN7206WSchimmel O L · Port Hueneme, CAN7206YSkyflite LLC · Hillsboro, ORN7207Board Of Trustees · Battle Creek, MIN7207DHerrick David L · Mont Vernon, NHN7207FLandmark Title Inc · Clovis, NMN7207GCowden Flying Services Inc · Fort Worth, TXN7207JErhardt Industries LLC · Ottumwa, IAN7207QMountain Peaks Aviation LLC · Clancy, MTN7207WValkaria Flyers LLC · Palm Bay, FLN7208DCopper River Airmotive LLC · Copper Center, AKN7208FWignot Andrew R · Oceanside, CAN7208GBurgess Keith · Arnoldsville, GAN7208JWelby Samantha · Eastampton, NJN7208WSky View Aviation LLC · Porter, OKN7209DBlue Weayne E · Rochester, NYN7209FNew Garden Township · Landenberg, PAN7209GElite Planes LLC · Menifee, CAN7209QKimble Leon · Rocky Hill, CTN7209YThy Will Be Done Here LLC · Reno, NVN720ACKcsi Aerial Patrol Inc · Bakersfield, CAN720CBLee Douglas A · Quincy, CAN720FLExecutive Flight Training & Services LLC · Sanford, NCN720GCCox Gary E · Davis, CAN720GPCharlie Hotel Corp · Wilmington, DEN720JPThomas Ryan J · Bend, ORN720LSBellotte Travis J · Morgantown, WVN720MGRegistered aircraftN720NWNunez Frank · Orlando, FLN720PAValiair Lc Trustee · Casper, WYN720RTLeaders Kurt W · Clear Lake, MNN720SGStaudacher Jon · Kawkawlin, MIN720SUOklahoma State University · Stillwater, OKN720TSSpencer David T · Dayton, OHN720UOhio University · Albany, OHN7210DRainey Lee S · Troy, MON7210FCedar Yopanz Flying Club LLC · Las Vegas, NVN7210GOgle Howard J · Moorpark, CAN7210HMenzie Bradley J · Sublette, KSFirst renewal noticeN7210JBoling Kenneth A · Greenbrier, ARN7210KDean Alan L · Soldotna, AKN7210QAthol Orange Aero Club Inc · Athol, MA
Back to AD 90-04-06 R1