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.
N7044ABradley Shannon C · Carrsville, VAN7044FHanson Mike D · Vinton, IAN7044GSpitzbart David G · Woodstock, ILN7044SNorthern Virginia Flying Club Inc · Aldie, VAN7044XKlenoski Brian D · Fulton, MIN7045QDavidson Parker · Redding, CAN7045SDiblasi Francis L · Shelton, CTN7045TDougherty Peter G · Yakima, WAN70462Alis Russell D · Fairbanks, AKN70468Poschwatta Jeffrey R · Kent, WAN7046MCrosby Kenneth R · Trapper Creek, AKN7046QRicken Kent · Boone, CON7047EWhitley Steven · Auke Bay, AKN7047FVanderlei Lowell B · Springfield, SDN7047MAtkins Daniel S · Verona, WIN7047SHaley William R III · Carrollton, GAN7047TPetersen Derrick D · Sibley, IAN70487Picazo Daniel M · Rogersville, TNN70488Hand Kevin D · Anchorage, AKN7048EHarrison Donald R · Lake Havasu City, AZN7048HMuise Jason A · Windham, NHN7048QFirelight Academy LLC · Brush, CON7048THenegar Robert A · Newhope, ARFirst renewal noticeN7048XGartner Thomas M · Newton, KSN70493Starnes Michael A · Murfreesboro, TNN7049ATjernjund Wesley Gordon · Salem, ORN7049GLouisville Aircraft Leasing LLC · Louisville, KYN7049HAir Bound Aviation LLC · Fairfield, NJN7049MBarnett Ruben · Bardstown, KYN7049QVortex Aero LLC · Lakeland, FLN704AAWasatch Industries LLC · Ogden, UTN704ACRegistered aircraftN704AEYocom Jason D · Cocoa, FLN704AHN704ah LLC · Darien, WIN704AMAmerican Resources Inc · Harlan, KYN704ASAuger Allan D · Conifer, CON704ATLongnecker Michael · Stuttgart, ARFirst renewal noticeN704AULosey Rodric O · Nipomo, CAN704AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN704AWKroeger Dean · Two Rivers, WIN704AYAndreasen Mark D · Ridgefield, WAN704AZFrantz Dean A · Adrian, MIN704BEGore Cleveland · Manning, SCN704BGJones Kermit L III · Jasper, ALN704BHCloud Buddies LLC · Charlotte, NCN704BMEdwards Richard V · Acampo, CAN704BNWipaire Inc · South Saint Paul, MNN704BRRourke William P · Lavonia, GAN704BZFranks John W · Barberton, OHN704CACircle S Aviation LLC · Starkville, MS
Back to AD 79-10-14 R1