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.

N8402MBurke Shawn T · Flowery Branch, GABuilt 1969 · S/N A1500102 N8402TNalty Shannon P · Queen Creek, AZBuilt 1959 · S/N 52302 N8402UWj Rothwell Ranch Co · Hyannis, NEBuilt 1964 · S/N 17252302 N8402XDominy Geary B · Flint, TXS/N 17248902 N8402ZRixford Raymond Gould · Gunnison, COBuilt 1963 · S/N 205-0402 N84036Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258308 N8403QWallace Andrew M · Salt Lake City, UTBuilt 1978 · S/N 18503684 N8403UAnderson Larry L · Silver City, NMBuilt 1964 · S/N 17252303 N84048Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 17258314 N8404JMalphurs Larry Neil · Pooler, GAS/N 15066304 N8404MMitchell Ryan G · Ventura, CABuilt 1969 · S/N A1500104 N8404TMichels Lon · Plentywood, MTBuilt 1959 · S/N 52304 N8404UAviation Career Enrichment Inc · Atlanta, GABuilt 1964 · S/N 17252304 N8404XHousel LLC DBA · Palm Harbor, FLS/N 17248904 N8404ZSmith Michael E · Willits, CABuilt 1963 · S/N 205-0404 N84050Alpenglow Air 2 LLC · Anchorage, AKBuilt 1969 · S/N 17258315 N8405QVan Pelt Matthew · Challis, IDBuilt 1976 · S/N U20603265 N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319 N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N8406SSkydive Central New York LLC · Weedsport, NYBuilt 1965 · S/N 18256506 N8406UGrzincich Michael J · Coon Rapids, MNBuilt 1964 · S/N 17252306 N8406ZBarsto Aviation Inc · Wilmington, DEBuilt 1963 · S/N 205-0406 N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322 N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323 N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N8407MJohnson Michele J · Buena Vista, COBuilt 1969 · S/N A1500107 N8407SRottinghaus Charles A · Waterloo, IABuilt 1965 · S/N 18256507 N8407TRegistration Pending · Norway, IARegistration pendingBuilt 1959 · S/N 52307 N8407XDouthett Fontaine · Deland, FLBuilt 1961 · S/N 17248907 N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326 N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327 N8408UMastey Patrick R · Saint Cloud, MNS/N 17252308 N8408ZRegistered aircraftBuilt 1963 · S/N 205-0408 N84092Brown Stephen J · Chandler, AZBuilt 1969 · S/N 17258328 N84093Hruska Coyle J · Lime Springs, IABuilt 1969 · S/N 17258329 N84097Argoudelis Michael · Kalamazoo, MIS/N 17258331 N84099650 Aviation LLC · San Mateo, CABuilt 1973 · S/N 18261853 N8409GOberholzer Craig C · Stanley, NCS/N 15062509 N8409LRegistered aircraftBuilt 1968 · S/N 17256609 N8409QFrey David G Jr · Grand Rapids, MIBuilt 1976 · S/N U20603269 N8409SKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1965 · S/N 18256509 N8409XAlbers Stanley F · Hazlet, NJBuilt 1961 · S/N 17248909 N84104Morris Daniel B · Ankeny, IABuilt 1969 · S/N 17258334 N84105Jost Jared D · Hillsboro, KSS/N 17258335 N84108Bramblett John S · Russellville, ARBuilt 1969 · S/N 17258337 N8410ETito Hector · Fayetteville, GABuilt 1979 · S/N 17272196 N8410J1st Flight LLC · Allentown, PABuilt 1967 · S/N 15066310 N8410LVictory Lane Aviation LLC · Concord, NCBuilt 1968 · S/N 17256610

Back to AD 87-20-03 R2