Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N1737FVoltl Mike N · Coloma, WIS/N 17255132 N1737MClinton Aviation Corp · Clinton, ARBuilt 1975 · S/N 18264423 N1737QWilliams Kamille N · Juneau, AKS/N 15073037 N1737RMorales Richard · Palm Springs, CABuilt 1978 · S/N R18200541 N1737VWatson Patrick D · Kenyon, MNBuilt 1974 · S/N 17263732 N17382Hagelstein Ele C · Sanderson, TXRegistration expired, pending cancellationBuilt 1972 · S/N 15073715 N1738FWesley Emerson Holdings LLC · Clifton, TXBuilt 1966 · S/N 17255133 N1739COpp Daniel · Anchorage, AKBuilt 1953 · S/N 30439 N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134 N173BADunlap Jolene · Peoria, ILBuilt 1979 · S/N 17272370 N173KADaigle Lawrence J · Cohasset, MNBuilt 1972 · S/N 17260939 N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781 N173LLRegistration Pending · Barrigada, GURegistration pendingBuilt 1982 · S/N 17275633 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364 N173RGBuchert Christine W · SchweinfurtBuilt 1980 · S/N 172RG0218 N173RJJohnston Ronald E · Seattle, WAS/N 26269 N173SKS Kamat Inc · Lexington, KYS/N 17272108 N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090 N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157 N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781 N173YAHoekman Kenneth J · Sherwood, ARBuilt 1980 · S/N 17274191 N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135 N1741CWitt William A · Ennis, MTBuilt 1953 · S/N 30441 N1741MWolfehagen Paul B · Phoenix, AZS/N 33701341 N1742FMarsteller Bruce Paul Jr · Greensburg, PABuilt 1966 · S/N 17255137 N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1743DCranton Larry J · Mesa, AZBuilt 1952 · S/N 20343 N1743FLittle Bird Airways LLC · Hamburg, NYBuilt 1966 · S/N 17255138 N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463 N1743VRegistered aircraftBuilt 1974 · S/N 17263736 N1744DJones William H Trustee · Wenden, AZBuilt 1951 · S/N 20187 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1745DStuczynski Jason S · Justin, TXBuilt 1951 · S/N 20188 N1745FClary David D · Elk Grove Village, ILBuilt 1966 · S/N 17255140 N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465 N1746CGreen Gary Dale · Mccarthy, AKBuilt 1953 · S/N 30446 N1746RSky West Aviation Inc Trustee · Albuquerque, NMS/N R18200543 N1746ZThompson Nathan G · San Antonio, TXS/N 336-0046 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1747CConatser Patrick M · Homeland, CABuilt 1953 · S/N 30447 N1747FSmith Jason F · Ronkonkoma, NYBuilt 1966 · S/N 17255142 N1747MMcmillan James D · Abilene, TXBuilt 1975 · S/N 18264425 N1747QAleyda Aviation LLC · Berlin, NJBuilt 1972 · S/N 15073047 N1747RFite Rodney Edward · San Lorenzo, CABuilt 1978 · S/N R18200544 N1748DWilliams Bobby G · Simi Valley, CABuilt 1951 · S/N 20191 N1748FManning Malcolm · Senatobia, MSBuilt 1966 · S/N 17255143 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348

Back to AD 87-20-03 R2