Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N8927JTipton Thomas G · Walnut Grove, MOS/N 28-2945 N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724 N8927WFiihr Travis A · Grand Junction, COBuilt 1964 · S/N 28-10492 N8928JHaybron David M · Sewickley, PABuilt 1965 · S/N 28-2946 N8929JRice Spencer F · Portland, ORBuilt 1965 · S/N 28-2947 N8929WSimmons Ralph R Jr · Sadler, TXBuilt 1964 · S/N 28-10494 N892ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881398 N892DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020041 N8930JMccracken Blake R · Lake Havasu City, AZBuilt 1965 · S/N 28-2948 N8930WMaurer Mark · Alamogordo, NMBuilt 1964 · S/N 28-10495 N8933JQuilling John R · Cannon Falls, MNBuilt 1965 · S/N 28-2950 N8933WFlight Time LLC · Portland, ORBuilt 1964 · S/N 28-10500 N8934WNelson Cy D · Decorah, IABuilt 1964 · S/N 28-10501 N8935WJudd Ellen K · Burley, IDS/N 28-10502 N8936JCloud Niners Inc · Brownsburg, INBuilt 1965 · S/N 28-2953 N8937NSchewe William M · Greenville, ILFirst renewal noticeBuilt 1969 · S/N 32-40735 N8937WArmstrong Wanliss E · Jal, NMBuilt 1964 · S/N 28-10504 N8938JMeier Daniel J · Greenwood, INBuilt 1965 · S/N 28-2955 N8939CRegistration Pending · Lakota, NDRegistration pendingS/N 28-7615133 N8939JEstis Jonathan D · Walden, NYBuilt 1966 · S/N 28-2956 N8939NOakley William J · Kildeer, ILBuilt 1969 · S/N 32-40741 N893ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881412 N8940JMullins David H · Zebulon, GABuilt 1965 · S/N 28-2958 N8941JTilghman Michael B · Salisbury, MDBuilt 1965 · S/N 28-2959 N8941WSalisbury Airplane Associates Inc · Berlin, MDBuilt 1966 · S/N 28-10809 N8942NMinnema Samuel S · Fairbanks, AKS/N 32-40742 N8943JHuber Steven C · Hernando, MSBuilt 1966 · S/N 28-2961 N8943NChase-Six LLC · Orange Park, FLBuilt 1969 · S/N 32-40744 N8943WBlack Paul D · Auburn, CABuilt 1964 · S/N 28-10512 N8944CHarris Ryan A · Valley Cottage, NYBuilt 1976 · S/N 28-7615134 N8945JFischer Thomas F · Troy, ILBuilt 1965 · S/N 28-2963 N8946CPilawski Darren J · Spring Hill, FLBuilt 1976 · S/N 28-7690171 N8946J2mec Holdings LLC · Kalispell, MTBuilt 1965 · S/N 28-2964 N8946WBeck Adam J · Mulberry, INBuilt 1964 · S/N 28-10517 N8947NGarfield Air LLC · Burwell, NEBuilt 1970 · S/N 32-40921 N8947WWard Marcus K · Payette, IDBuilt 1964 · S/N 28-10519 N8948CKrupnik Amnon · Bethesda, MDBuilt 1976 · S/N 28-7690172 N8948JAlbright Frank E · Ashley, INS/N 28-2968 N8948NC6 Flying LLC · North Logan, UTBuilt 1970 · S/N 32-40750 N8948WGarrison Randy M · Plains, MTBuilt 1964 · S/N 28-10520 N8949CMorgan Aviation LLC · Greensboro, NCBuilt 1976 · S/N 28R-7635186 N8949JSchmidt Roger L · Plattsmouth, NEBuilt 1965 · S/N 28-2969 N8949WSullivan Sean · Fort Worth, TXBuilt 1964 · S/N 28-10522 N894ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881413 N894MAHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020134 N8950NWatson Richard D · Plant City, FLS/N 32-40751 N8950WEthington Scott · Emmett, IDS/N 28-10523 N8951JMoehle Colleen M · Lincoln, ILBuilt 1966 · S/N 28-2971 N8952CZell Zulu LLC · Greensboro, NCBuilt 1976 · S/N 32-7600010 N8952JSolley Aviation LLC · Nebo, NCS/N 28-2972

Back to AD 87-08-08 R3