Skip to content

Registered aircraft · 54,015

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.

N64181Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275529 N64183Chiappe Glenn R · Lago Vista, TXBuilt 1977 · S/N 18052877 N64184Arlington Flight Services Inc · Arlington, WABuilt 1975 · S/N 17265071 N64186Paraloft LLC · Mims, FLBuilt 1975 · S/N 17265072 N6418DAirways Aviation Inc · Grand Rapids, MNBuilt 1979 · S/N 17272793 N6418ELima-001 LLC · Muscatine, IAS/N 17272019 N6418TRobo Flight Air Support LLC · Inver Grove Height, MNBuilt 1985 · S/N R18202016 N6418XCoffman David W · Wilbur, WABuilt 1960 · S/N 18050918 N64191Flycarolina LLC · Concord, NCBuilt 1975 · S/N 17265076 N64192Skyhawk Transport LLC · Hazel Green, ALBuilt 1975 · S/N 17265077 N64198Randy Goering Inc · Bend, ORBuilt 1975 · S/N 17265080 N64199Mutschler George Robert Jr · Bayfield, COBuilt 1975 · S/N 17265081 N6419BMarshall Timothy M Trustee · Tucson, AZBuilt 1978 · S/N 21062762 N6419MWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284718 N6419VUrbana Aircraft LLC · Urbana, MDBuilt 1980 · S/N 172RG0680 N6419XPernat Frank J Trustee · Chaska, MNBuilt 1980 · S/N U20605877 N641ABDaccarett Marcos · Boise, IDS/N 182-67178 N641DACavu Aviation LLC · Lake Geneva, WIBuilt 1970 · S/N 18501619 N641MRoyo Marco · Canutillo, TXBuilt 1976 · S/N 21061641 N641TAAk Leasing LLC · Orchard Lake, MIBuilt 1978 · S/N 18266599 N64201Registration Pending · Lander, WYRegistration pendingBuilt 1975 · S/N 17265083 N64203Vance Nicholas D · Bluffton, OHS/N 17265084 N64205Mulligan George G Trustee · Friday Harbor, WABuilt 1977 · S/N 18052880 N64209Kay Roland C · Wasilla, AKS/N 17265090 N6420AAbidance Inc · Winthrop, WABuilt 1956 · S/N 33220 N6420BAlpha International Aircraft Inc · Lewes, DES/N 15283930 N6420FWilson Christopher Derrick · Ovilla, TXBuilt 1966 · S/N 15063020 N6420MJensen Aviation Inc · Zephyrhills, FLBuilt 1980 · S/N 15284719 N6420NSouth Aero LLC · Albuquerque, NMBuilt 1981 · S/N 18504307 N6420TJetran LLC · Horseshoe Bay, TXS/N R18202017 N6420VKorson James · Yorkville, ILBuilt 1980 · S/N 172RG0681 N6420XHarmon Jeremy Scott · Ely, MNBuilt 1960 · S/N 18050920 N6420YFlying Amigos Aviation LLC · Las Cruces, NMBuilt 1981 · S/N 21064370 N64211Miller Paul F · Whitefish, MTBuilt 1977 · S/N 18052881 N64213Ajc Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 17265093 N64215Registered aircraftBuilt 1975 · S/N 17265095 N64217Simplifly LLC · Mesa, AZBuilt 1975 · S/N 17265097 N64219American Patrols Inc · Midland, TXBuilt 1975 · S/N 17265098 N6421AAllen Khaled Charles · Berkeley, CABuilt 1956 · S/N 33221 N6421BNord Andrew E · West Columbia, SCBuilt 1956 · S/N 29621 N6421EOsborn Jon C · Groveland, FLBuilt 1959 · S/N 46521 N6421FBixby Paul A · Vale, ORBuilt 1966 · S/N 15063021 N6421SKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 15067221 N6421XDinstel Delbert F · Park City, MTBuilt 1960 · S/N 18050921 N6421YHulett Gregory · Las Vegas, NVBuilt 1981 · S/N 21064371 N64220Wieman Dianne L · Marion, TXBuilt 1975 · S/N 17265099 N64224Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 17265103 N64228Abbott Cedric M · Buckfield, MEBuilt 1975 · S/N 17265105 N6422AColby Clayton L · Kalispell, MTBuilt 1956 · S/N 33222 N6422FClark James H · Pittsfield, MABuilt 1966 · S/N 15063022

Back to AD 87-20-03 R2