Skip to content

Registered aircraft · 6,915

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

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:97-01-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:97-01-01-R1') ORDER BY n_number

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:97-01-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:97-01-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:97-01-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:97-01-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.

N4984SLinair LLC · Lewes, DEBuilt 1970 · S/N 28R-35704 N4985JEri-Aero Land Partners LLC · Flower Mound, TXBuilt 1968 · S/N 28R-30739 N4985TPope Donald R · Enid, OKBuilt 1972 · S/N 28R-7235167 N4986JMcelhiney Lance V · Harker Heights, TXBuilt 1968 · S/N 28R-30740 N4987JFulco Jason E · Frisco, TXS/N 28R-30742 N4989JEastern Florida State College · Cocoa, FLBuilt 1968 · S/N 28R-30744 N498CCShephard Russell Steven · Gallatin, TNBuilt 1976 · S/N 28R-7635447 N4990JEstes Aviation LLC · Vicksburg, MSBuilt 1968 · S/N 28R-30746 N4992FGregory Aviation LLC · San Jose, CABuilt 1976 · S/N 34-7770005 N4992JBas Part Sales LLC · Greeley, COBuilt 1968 · S/N 28R-30748 N4994JCrowe Justin L · Tompkinsville, KYS/N 28R-30750 N4994SSmith Thomas C · Norfolk, VABuilt 1970 · S/N 28R-35719 N4995BStobbe Marlin L · Granada Hills, CAS/N 24-4501 N4995SNova Aero LLC · Ontario, ORBuilt 1970 · S/N 28R-35720 N4996JLee Matthew · Magnolia, TXBuilt 1968 · S/N 28R-30752 N4996SChabrian Jerry W · Daytona Beach, FLBuilt 1970 · S/N 28R-35721 N4999SStaples Chad V · Efland, NCBuilt 1970 · S/N 28R-35724 N499FCFoxtrot Charlie Aviation LLC · Charlotte, NCBuilt 1976 · S/N 32R-7780076 N499XMParis Air Inc · Vero Beach, FLS/N 347250259 N49HDSasnak Inc · Wichita, KSS/N 28R-7803104 N49LBOwen Walter M · Arlington, TNBuilt 1976 · S/N 32R-7680481 N49WSJohnson Matthew N · Redgranite, WIBuilt 1966 · S/N 30-1393 N4BRRoberts Boyd · Celeste, TXBuilt 1973 · S/N 28R-7335423 N4CBDream Catcher Company LLC · Center, COBuilt 1964 · S/N 24-3607 N4CKLorenzo Walker Institute Of Technology · Naples, FLBuilt 1967 · S/N 30-1645 N4PLJuliet Kilo Aviation LLC · Palos Heights, ILBuilt 1961 · S/N 24-2400 N4WBBe Positive Holdings LLC · Bloomsburg, PABuilt 1977 · S/N 32R-7880018 N4XNMiller Donald W · Harrisonburg, VABuilt 1971 · S/N 244990 N4YASoaring Eagle Southwest LLC · Fort Mohave, AZS/N 30-365 N5002POrtman Bernard · Deer Park, TXBuilt 1957 · S/N 24-5 N5002SAsasnoceu LLC · Fort Myers, FLBuilt 1970 · S/N 28R-35726 N5003PLouwagie Bradley J · Marshall, MNFirst renewal noticeBuilt 1957 · S/N 24-6 N5005PRackley William R Jr · Grand Island, FLBuilt 1957 · S/N 24-8 N5006PWright William · Cleveland, OKBuilt 1957 · S/N 24-9 N5007SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N 28R-35731 N5008PThree Chicks Aviation LLC · Benton, LAS/N 24-11 N500AVInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 24-4805 N500DPO'Rourke Lawrence · Montgomery, PAS/N 28R-30391 N500DTBlackhawk Holding Corp · Wilmington, DEBuilt 1977 · S/N 34-7770260 N500GLEumundi Trading Company · Wilmington, DEBuilt 1978 · S/N 28R7803284 N500NPVolare Air LLC · Palm Harbor, FLBuilt 1974 · S/N 28R-7435168 N500PFord Charles D · Clifton, TNS/N 24-341 N5010SAeroflyte LLC · Glastonbury, CTBuilt 1970 · S/N 28R-35735 N5010TN5010t LLC · Arcadia, OKS/N 28R-7235171 N5013SFlightworks LLC · North Myrtle Beach, SCBuilt 1970 · S/N 28R-35740 N5013TDasilvafontoura Peterson · Santa Clarita, CABuilt 1972 · S/N 28R-7235173 N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17 N50169Goddard Jake W Jr · Perry, GAS/N 32R-7680110 N5017PPineapple Air LLC · Wilmington, DEBuilt 1957 · S/N 24-20 N5019SGordon Patricia I · Desoto, TXS/N 28R-35751

Back to AD 97-01-01 R1