Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N72863Escovedo Ricky L · Oroville, CAS/N 10054 N72865Schmidt Victor · Goldendale, WAS/N 10056 N72867Vega Abraham · Del Rio, TXBuilt 1946 · S/N 10058 N7286ALipp James Oliver · Nesconset, NYBuilt 1956 · S/N 29386 N7286GRegistered aircraftBuilt 1973 · S/N 15074636 N7286SMaychezak Lana R · Sentinel Butte, NDBuilt 1967 · S/N 15067986 N7286XKillian James D · Oakwood, GABuilt 1961 · S/N 15059386 N72876Legan Howard Daniel · Las Vegas, NVBuilt 1946 · S/N 10067 N72878Doughty Frank · North Andover, MABuilt 1946 · S/N 10072 N7287ADean William D · Jasper, GABuilt 1956 · S/N 29387 N7287MFrenzel Carl O · Midlothian, TXBuilt 1958 · S/N 55587 N7287TRfk Aerospace LLC · Clayton, NCBuilt 1959 · S/N 46887 N72881Jenkins Joan C · West Columbia, SCBuilt 1946 · S/N 10075 N72885George Richard · Holmen, WIBuilt 1946 · S/N 10079 N7288AHeard Benjamin A · Ellensburg, WABuilt 1956 · S/N 29388 N7288MStraight Tail LLC · Boise, IDBuilt 1958 · S/N 55588 N7288TSandusky Flight Academy LLC · Sandusky, MIBuilt 1959 · S/N 46888 N72891Steiner Zachary J · Bethlehem, CTS/N 10085 N72894Registered aircraftBuilt 1946 · S/N 10088 N72897Chamberlain Kendall · Frisco, TXS/N 10091 N7289SHancock Deborah M · Hayes, VABuilt 1967 · S/N 15067989 N7289TShepherd Gary D · Owosso, MIBuilt 1959 · S/N 46889 N728LCHeath Richard · Raymondville, TXBuilt 1974 · S/N 15075773 N72900Guske Brad H · Montrose, CAS/N 10094 N72902Fischer Lee F · Larned, KSBuilt 1946 · S/N 10096 N72904Bryan Andrew R · Eureka, CABuilt 1946 · S/N 10098 N72907Maggart Kenneth R · Lutz, FLBuilt 1946 · S/N 10101 N72908Pate Charles C Trustee · Wichita, KSBuilt 1946 · S/N 10102 N7290ARipp Fred G · Eagle River, AKBuilt 1956 · S/N 29390 N72911Garrison Kevin · Lexington, KYS/N 10105 N72913Kinsey Roy M Jr · Pensacola, FLBuilt 1946 · S/N 10107 N72915Engelking William S · Detroit Lakes, MNBuilt 1946 · S/N 10109 N72917Walker Ray · Sanger, TXS/N 10111 N7291AWarren Mark W · Arlington, WAS/N 29391 N7291BBognar Jeffrey L · Kinnelon, NJBuilt 1946 · S/N 10108 N7291HDavis David H · Chugiak, AKBuilt 1946 · S/N 20550 N7291KCassell Robert W · Wasilla, AKBuilt 1950 · S/N 18-203 N7291MLee Brainard E · Everett, WABuilt 1958 · S/N 55591 N7291TThomas Charles A · Hockley, TXBuilt 1959 · S/N 46891 N7291XWaterman David K · Temple City, CAS/N 15059391 N72922Registered aircraftBuilt 1946 · S/N 10120 N72926Williams Andrew B · Mineral Wells, TXBuilt 1946 · S/N 10124 N7292TObloy James J · Brunswick, OHBuilt 1959 · S/N 46892 N72930Fox Industries Of Ms Inc · Canton, MSS/N 10128 N72932Healis William J · Scottsdale, AZS/N 10130 N72937Bardo Daniel J · Salem, OHBuilt 1946 · S/N 10135 N72938Heitz John · Manvel, TXBuilt 1946 · S/N 10136 N7293SGraham John T · Phoenix, AZBuilt 1967 · S/N 15067993 N7293TMccamant Angus J · Alohu, ORBuilt 1959 · S/N 46893 N72943Parsons Douglas L · Carrollton, OHBuilt 1946 · S/N 10141

Back to AD 94-05-05 R1