AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N9931ARowland Brett D · Wichita, KSN9931BLevin Lawrence W · Glencoe, ILFirst renewal noticeN9931EN9931e LLC · Phoenix, AZN9931HEnergy Transfer Aviation LLC · Spring, TXN9931QDexter Aero Club Inc · Stetson, MEN9931THanft Douglas N · Raymond, CAN99329Tactical Integrated Training Soluctions LLC · San Antonio, TXN9932EMiller Mike R · Redmond, WAN9932GT & M Aircraft LLC · Monticello, ILN9932HFlathead Flight Operations LLC · Kalispell, MTN9932NGetz Keith · Murfreesboro, TNN9932ZSilver Creek Aviation Services · Fort Worth, TXN99338Civil Air Patrol Inc · Maxwell Afb, ALN9933ATravelair Inc · Ocala, FLN9933BHenkemeyer Joseph S · Cave Creek, AZN9933MAlaska Aircraft Leasing LLC · Silverdale, WAN9933TOrr Kory A · Hay Springs, NEN9933ZFreelance Air · Kennesaw, GAN99341Jlinn Aviation Inc · Quinlan, TXN99344Global Tours & Travel Services LLC · Davie, FLN99347Skywarrior Flight Training Inc · Pensacola, FLN9934BMasterson Kevin M · Eagle River, AKN9934EStenger D James Trustee · Sonora, CAN9934GDiorio Christopher J · Melba, IDN9934NAtkins Ricky K · Placerville, CAN9934QDoupe Services LLC · Fort Myers, FLN9934VRuby Aviation LLC · Oak Creek, CON9934XLogue James · Fort Worth, TXN9934ZParagon Air Group · Fort Worth, TXN9935AMichael Monte E · Axtell, TXN9935BCarpenter Willard D · Borrego Springs, CAN9935ERegistration Pending · Belington, WVRegistration pendingN9935FKrahe Richard P · Willoughby, OHN9935HKahn Lawrence · Upper Lake, CAN9935MFreshwater Adventures Inc · Dillingham, AKN9935NMeggers Roger D · Baker, MTN9935RUsda Aphis Ppq · Edinburg, TXN9935VD & S Aviation LLC · Wilmington, DEN9936QHunt Richard M · Columbus, OHN9936VLeading Edge Flight Academy LLC · Bend, ORN99377Barta Terry · Faribault, MNN9937AInternational Air Services Inc Trustee · Carson City, NVN9937E7 And 7 LLC · Leon, IAN9937QFosmo Richard E · Eatonville, WAN9938NJohnson Scott A · Missoula, MTN9938TShope Brandon M · North Pole, AKFirst renewal noticeN9938ZSilver Creek Aviation Services · Fort Worth, TXN99396Flightline Air Service LLC · Pineville, LAN9939NSylvester Sean W · North Pole, AKN9939VJackson Walter E · Wasilla, AK
Back to AD 79-10-14 R1