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.

N73100Alaska Air Taxi LLC · Anchorage, AKBuilt 1979 · S/N 20700559 N73103Bfl Aviation LLC · Bakersfield, CABuilt 1976 · S/N 17267267 N73105Jlk Management LLC · Kerrville, TXBuilt 1976 · S/N 17267268 N7310GMccall Freddie W Jr · East Brewton, ALBuilt 1970 · S/N 17259010 N7310QDye Development LLC · Salem, OHBuilt 1972 · S/N 18260950 N7310TYowell Albert W · Etlan, VABuilt 1959 · S/N 46910 N73113Top Flight Aviation Inc · Corona, CABuilt 1976 · S/N 17267269 N73116Taildraggers Flyers Inc · Saint Joseph, MIBuilt 1976 · S/N 17267272 N73118Hudson Donald L Jr · Sellersburg, INBuilt 1975 · S/N 18264122 N7311SDayton Pilots Club Inc · Germantown, OHBuilt 1981 · S/N R18201703 N7311VWiliams Daniel L · Liverpool, NYBuilt 1977 · S/N R1722303 N73123Lake Clark Air Inc · Port Alsworth, AKBuilt 1979 · S/N 20700561 N7312AJohnson Thomas F · Buckeye, AZS/N 29412 N7312GKlitzke Lucanus E · La Plata, NMBuilt 1973 · S/N 15074644 N7312NOber John · Candor, NYS/N 18263097 N7312QRegistration Pending · Wilmington, DERegistration pendingBuilt 1972 · S/N 18260952 N7312SCuneo Timothy Angelo · Twin Falls, IDBuilt 1976 · S/N 18265104 N7312THangar 20 Flying Club LLC · Climax, MIS/N 46912 N7312WRegistered aircraftBuilt 1977 · S/N R18200053 N7312XFellows Thomas C · Prescott, AZBuilt 1977 · S/N R18200071 N73131Fremont Flight Academy LLC · Fremont, OHBuilt 1976 · S/N 17267280 N73134Harborside Aviation Services Inc · Punta Gorda, FLBuilt 1976 · S/N 17267281 N7313APerkins David A · Locust Grove, OKS/N 29413 N7313GBend-Over Hill Aviation LLC · Dover, DEBuilt 1973 · S/N 15074645 N7313QWoodall Dan · Raleigh, NCFirst renewal noticeBuilt 1972 · S/N 18260953 N7313SRogers Matthew H · South Berwick, MEBuilt 1976 · S/N 18265105 N73146Oregon State Flying Club Inc · Corvallis, ORBuilt 1976 · S/N 17267287 N73148Kinney Transportation · Columbia, MOBuilt 1976 · S/N 17267289 N73149Good Flight Aviation LLC · Stockton, CABuilt 1976 · S/N 17267290 N7314ASchultz David · Middleton, IDBuilt 1956 · S/N 29414 N7314GKittle Aviation LLC · Wichita, KSBuilt 1970 · S/N 17259014 N7314MFrickel Daniel R · Atkinson, NEBuilt 1958 · S/N 55614 N7314TCarney Mark A · Emporia, KSBuilt 1959 · S/N 46914 N73151Hawaii Aviators LLC · Ewa Beach, HIBuilt 1976 · S/N 17267292 N73154Bishop Services LLC · Ellisville, MSBuilt 1976 · S/N 17267293 N7315ATiny Sparrow Aviation LLC · Irvine, CAS/N A1500709 N7315KLittle James R Jr · Jackson, WYBuilt 1976 · S/N R1722053 N7315MRolling Cole LLC · Kalispell, MTBuilt 1959 · S/N 55615 N7315QNotman Steven J · Maunaloa, HIBuilt 1972 · S/N 18260955 N7316ALangley Russell M · Adair, OKBuilt 1956 · S/N 29416 N7316GCox Capital LLC · Rushville, MOS/N 17259016 N7316MSteven Bryant · Boise, IDS/N 55616 N7316NHayes Charles David · North Pole, AKBuilt 1974 · S/N 18263100 N7316QAirborne LLC · Wilmington, DEBuilt 1972 · S/N 18260956 N7316XMattson Nicholas R · Vail, AZBuilt 1961 · S/N 15059416 N73170Jahawk Leasing LLC · Sugar Grove, ILBuilt 1976 · S/N 17267297 N73171Jettmar Rainer U · Washington, DCBuilt 1976 · S/N 17267298 N73172American Patrols Inc · Midland, TXBuilt 1976 · S/N 17267299 N73174Welch Cleatus E · Orlando, FLBuilt 1976 · S/N 17267301 N73178G P Holding Inc · Mora, MNBuilt 1976 · S/N 17267305

Back to AD 87-20-03 R2