AD 91-08-07
Registered aircraft · 6,062
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:91-08-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-08-07')
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:91-08-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-08-07') 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.
N1089GMooney Technical Services LLC · Norfolk, VAN108ACKaplan Steven M · Key Largo, FLN108JLStar Marianas Aviation School Inc · Saipan, MPN108NSLyon Andrew L · Fairbanks, AKN108TLDomus Capital Holdings LLC · Dallas, TXN1090LKeull Warren W · Needville, TXN1091AMooney N1091a LLC · Broomfield, CON1091LMoonair Inc · Wilmington, DEN1099JLee'S Sea Air Inc · Kiana, AKN109ATAguillard Robert N · Memphis, TNN109CCTrans-Caribbean Air Exp & Imp Inc · Miami, FLN109FCUsda Forest Service Fepp · Tallahassee, FLN109JWGoldasich John K · Lomita, CAN109MBFirefly Aviation LLC · Midland, TXN10BGHemingway Donald S · Davidson, NCN10DKVillage Air LLC · Wichita, KSN10DLMoul Daniel P · Hanover, PAN10JKZalan Aviation LLC · Cincinnati, OHN10KGSeek Health Pllc · Naples, IDN10MAPatterson Casey Paul · Kinston, ALN10PJMiller Kenneth R · Russellville, KYN10QBAsc Aviation LLC · Brandon, MSN10YCToyz Aviation LLC · Worthington, KYN10YRAj Aviation LLC · Colby, KSN110AVCarter Jay W Jr · Wichita Falls, TXN110STBright Dale A · Limestone, TNN110WBFerrin Aviation LLC · Rome, GAN1110AMoore John C DBA · San Miguel, CAN11111Star Flight LLC · Bellevue, WAN1111MRw Air LLC · Rock Hill, SCN11141Hoitsma Lynn F · Castlewood, SDN111CFGsm Tax & Insurance Inc · Naples, FLN111DLCresence LLC · Port Saint Lucie, FLN111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYN111EWimpy Scott · Griffin, GAN111GAGeorges Aviation Services Inc · Honolulu, HIN111LFZimmerman Leland · Center, CON111MWSaratoga 181 LLC · Mesa, AZN111PKScruggs Ken · Galloway, OHN111SEKeith Fischer · Gig Harbor, WAN111SNHalbert Kevin · Tyler, TXN111SXJcccs Land And Cattle LLC · Harrisburg, NEN111UCRcht LLC · Mason, OHN111WKMad-Con LLC · Ijamsville, MDN111WYN111wy LLC · Wilmington, DEN1122EVasey Igor · San Francisco, CAN112AANestor Richard · Portsmouth, NHN112HDJackson Larry D · Orlando, FLN112RMAppalachian Aviation LLC · Harrisonburg, VAN1139LMathewson Crews Aviation LLC · Indianapolis, IN
Back to AD 91-08-07