Skip to content

Registered aircraft · 26,231

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.

N18623Fleischmann Fred · Racine, WIBuilt 1972 · S/N 15073994 N18627Oberhansly Lucas C · Roy, WABuilt 1972 · S/N 15073998 N18628Paul William A · Windfall, INBuilt 1972 · S/N 15073999 N1862CCoffey Calvin A · Mckinney, TXBuilt 1953 · S/N 26006 N1862KGadis Ethan G · Etiwanda, CABuilt 1947 · S/N 4589 N1862YVakalis Kevin A · Chugiak, AKBuilt 1962 · S/N 17249462 N18630Gaddy Tyler Quintin · Advance, NCBuilt 1972 · S/N 15074000 N18634Bagge William J · East Longmeadow, MABuilt 1972 · S/N 15074004 N18637Vincent Addison J · Waynesburg, OHBuilt 1972 · S/N 15074006 N1863CWalch Brian A · Anchorage, AKBuilt 1953 · S/N 26007 N1863VSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 14043 N18640Smith David W · Elgin, SCBuilt 1972 · S/N 15074008 N18645Sorenson Mark A · Senoia, GAS/N 15074011 N18649Dixon Robert D · Derry, PABuilt 1972 · S/N 15074015 N1864CRegistered aircraftBuilt 1953 · S/N 26008 N1864M172 Fayette Inc · La Grange, TXBuilt 1955 · S/N 7BCM-328 N1864YHeckendorf Jon W · Ordway, COBuilt 1962 · S/N 17249464 N1865Lacey Warren A · Anamosa, IABuilt 1970 · S/N N1 N18656Larsen Steve · Colton, ORBuilt 1972 · S/N 15074019 N1865BSly Duane D · Platte, SDBuilt 1957 · S/N 6292 N1865EWhite Duane A · Wappingers Falls, NYBuilt 1946 · S/N 7AC-5432 N18663Van Dyke John · Hopkins, MIBuilt 1973 · S/N 15074025 N1866BMorrison William · Nashville, TNBuilt 1948 · S/N 6293 N1866KHeckman Kyle J · Lafayette, COBuilt 1947 · S/N 4593 N1866NSpivey Darwyn D · Guntersville, ALS/N 12110 N18674Vandervegt Nathan J · Juneau, AKBuilt 1972 · S/N 15074034 N18678Laviolette Stephen O · Dallas, TXBuilt 1972 · S/N 15074037 N1867NPasqualino Mark W · Ocala, FLBuilt 1946 · S/N 12111 N18686Duvoisin Tom Jr · Powell, TNBuilt 1972 · S/N 15074041 N1868KRuddell Farms LLC · Junction City, ORBuilt 1947 · S/N 4595 N18697Cannon Corey D · Elk Grove, CABuilt 1972 · S/N 15074049 N1869BKinach Virginia Ann Trustee · Laughlin, NVBuilt 1948 · S/N 6296 N1869CSale Reported · Gorham, MESale reportedBuilt 1953 · S/N 26013 N1869KChiappini Paul · Melrose, FLBuilt 1947 · S/N 4596 N186ARAircraft Holdings LLC · Morgantown, WVS/N 15077554 N1870KMiller Robert G · New Carlisle, OHBuilt 1947 · S/N 4597 N18716Gem LLC · San Clemente, CABuilt 1972 · S/N 15074056 N18718Layton Garner W · Rockingham, NCBuilt 1972 · S/N 15074058 N1871BSensor Paul A · Hampton, IABuilt 1948 · S/N 6298 N18723Simpkins Larry D · Williamson, WVBuilt 1972 · S/N 15074062 N18724Friedlin Jason B · Hallieford, VABuilt 1972 · S/N 15074063 N1872VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N 14052 N1872YKamp Implement Co · Belgrade, MTBuilt 1962 · S/N 17249472 N18731Rotormate LLC · Royse City, TXBuilt 1972 · S/N 15074069 N18733Hall Thomas R · Ford City, PABuilt 1972 · S/N 15074071 N18737Giamichael Thomas C · Hudson, NYBuilt 1972 · S/N 15074075 N1873COrion Aviation Aircraft LLC · Carlsbad, CABuilt 1953 · S/N 26017 N1873NBarbee Max C · Wharton, TXBuilt 1946 · S/N 12117 N1873YTullier Mary A · Talihina, OKS/N 17249473 N18745Andrews Clark N · San Diego, CABuilt 1972 · S/N 15074082

Back to AD 94-05-05 R1