AD 91-21-01 R1
Registered aircraft · 5,086
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-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.
N9284X84x Leasing LLC · Idaho Falls, IDN9285QJrb Aviation Ltd · Jasper, GAN92884Bas Part Sales LLC · Greeley, CON9288PLivingston Jerry D · Wichita, KSN9289PSvetlik Ludvik Julius · Victoria, TXN928HLJ & M Sales & Leasing LLC · Abingdon, ILN9292NN9292n LLC · Valdosta, GAN9292PRegistered aircraftN9292YWeisend Chad M · Logansport, INN9293PCenterline Holdings Inc · Camden, DEN9293YBecker Ryan · Sheldon, IAN9294PJensen Thomas · Durango, CON9295GMcavian LLC · Westworth Village, TXN9296NSunrider Aviation Inc · Irvine, CAN9296PStevens John W · Westlake Village, CAN9297P9797p LLC · San Angelo, TXN9298DAims Air LLC · Kingsport, TNN9299PFusion Flight Management LLC · Lake Havasu City, AZN9299XSchoepel Alexandra E Trustee · Templeton, CAN929DJA And S Flying Services Inc · Bristol, VAN929RRPanafax LLC · Wilmington, DEN92BLIsland Birds Inc · St Thomas, VIN92DMD & M Flyers LLC · Petoskey, MIN92ECStevens Faustin R · Kennewick, WAN92EJSecond Life Properties LLC · Salisbury, MDN92GTBlue Skies Aviation LLC · Riverdale, MDN92HDN242ak LLC · Ocala, FLN92HRSweetsholdings LLC · Lewisville, TXN92JWKennedy Donald R Jr · New Philadelphia, OHN92LLTanner Dave · Auburn, CAN9303PDyster Justin C · Coeur D Alene, IDN930KGGriggs Roger · Columbia, SCN930MDTab Associates Inc DBA · Port Saint Lucie, FLN930ZMirage 930 Corp Trustee · Wilmington, DEN9312PGregory John P · Riverside, CAN9313PPencosky Edward A Jr · Manorville, NYN9315PGrady Michael J · Farmington, NMN9316PProvost Stephen Nicholas · Saint Louis, MON9317PFutter John H · Whately, MAN9318PPorter Wayne · Phoenix, AZN931SAMarc Inc · Bolton, MSN9321PRegistered aircraftN9325PCody William James · South Lyon, MIN9327PKrb LLC · Rupert, IDN9329PLenders Insurance Solutions Group LLC · Ozark, MON9331PAmra Nabil · Chaska, MNN9333PSky West Aviation Inc Trustee · Albuquerque, NMN9338PDream Home Aviation Inc · New Smyrna Beach, FLN9339PBreznik John D · Bradford, PAN9342PTaulbee Gregory · Sarasota, FL
Back to AD 91-21-01 R1