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.
N7316QAirborne LLC · Wilmington, DEN7316XMattson Nicholas R · Vail, AZN73170Jahawk Leasing LLC · Sugar Grove, ILN73171Jettmar Rainer U · Washington, DCN73172American Patrols Inc · Midland, TXN73174Welch Cleatus E · Orlando, FLN73178G P Holding Inc · Mora, MNN73179Weengknutts 179 · Delta, UTN7317GSettles Lauren E · Owensboro, KYN7317SGoodman Jack A · Memphis, TNN73181Nurse Alex S · San Diego, CAN73182Savannah Airplanes Venture LLC · Myrtle Beach, SCN73183Sandwich Aviation Inc · Somonauk, ILN73189Ellie Air LLC · Mabank, TXN7318GMay Curtis · Joplin, MTN7318HMichaud Francis G · Marine St Crx, MNN7318MOttis David J · Norfolk, NEN7318SStahl K Joseph · Gainesville, TXN73190Flying J Enterprises LLC · San Antonio, TXN73192Nationwide Aviation LLC · Hudson Oaks, TXN73195Saratoga Flyers Inc · South Glens Falls, NYN73197Seward Kent · Parma, IDN73198Davis Jimmy R Jr · Wharton, TXN73199Performance Polymer Technologies LLC · Roscommon, MIN7319AHart George · Yuba City, CAN7319DN7319d LLC · Port Saint Lucie, FLN7319GPiguzov Yevgeniy · Hillsborough, NJN7319MCordes Hannah K · Winthrop, WAN7319QBassett Robert C · Gypsum, CON731AALandis Lloyd B · Ardmore, OKN731ABA & C Ag Aviation Inc · Unadilla, GAN731BGKutschera Theodore C DBA · Callicoon, NYN731BMBenaiah Holdings Corp · Marion, KYN731CENoe Aviation LLC · Vinton, IAN731CLNby Productions · Manassas, VAFirst renewal noticeN731CQD & K Aviation Inc · Milford, IAN731ECFitchett Bradley S DBA · Ellsworth, KSN731EQUnited States Department Of Agriculture · Edinburg, TXN731ESSky Tech Inc · Dorchester, NEN731FMNew Frontier Aviation LLC · Fort Benton, MTN731FPLihs Ryan J · Sioux City, IAN731GDRegistration Pending · Walnut, ILRegistration pendingN731GPUpshaw John L Jr · Claude, TXN731GTDigger Dougs Crop Dusting Services Inc · Hollandale, WIN731KWVann Dudley C DBA · Greenville, NCN731LACmk Aerial Inc · Sutton, NEN731LFMcneill Dudley T · Happy, TXN731MCFalk Arthur J · Southport, NCN731MJLake Chelan Helicopters LLC · Manson, WAN731MKMccormick Eugene C DBA · Tyler, AL
Back to AD 79-10-14 R1