Skip to content

Registered aircraft · 68,369

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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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:90-04-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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.

N13672Cape Aerial Tours DBA · Chatham, MABuilt 1974 · S/N 17262931 N13674Bentley Robert H · Lockport, ILBuilt 1974 · S/N 17262933 N13675Valz Thomas M · Cleveland, OKBuilt 1974 · S/N 17262934 N1367ALl Wings LLC · Minnetonka, MNBuilt 1951 · S/N 18-1196 N1367CFerguson Bruce W · Fort Peck, MTBuilt 1953 · S/N 18-2626 N1367PBuzzard Air Service LLC · Carleton, MIBuilt 1956 · S/N 23-416 N1367TN1367t LLC · Mount Dora, FLBuilt 1972 · S/N 28R-7235271 N1367WSelover Richard D · Colusa, CABuilt 1963 · S/N 2648 N13680Macvicar Angus C · Nantucket, MABuilt 1974 · S/N 17262937 N13681Davis Jerry L · Rural Retreat, VABuilt 1976 · S/N 17702453 N13682Moynihan Quinn A · Apple Valley, MNBuilt 1974 · S/N 17262939 N13683American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262940 N13684Matyas Martin M · Helena, OHS/N 17262941 N13685Lee Valley Inc · Tekamah, NEBuilt 1974 · S/N 17262942 N13686T Craft Aero Club Inc · Nampa, IDBuilt 1974 · S/N 17262943 N1368AMcknight Thomas N · Fredericksburg, TXBuilt 1951 · S/N 18-1197 N1368BStallings Jerry W · Ferriday, LABuilt 1983 · S/N 222 N1368URed Baron Flyers · Caledonia, MNBuilt 1976 · S/N 17267039 N1369Low Country Skyways LLC · Wilmington, DEBuilt 1969 · S/N RLG-316 N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454 N13692American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262946 N13693Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17262947 N13696Johnson Mildred J Executor · Boerne, TXBuilt 1974 · S/N 17262950 N13698Park Avenue Group Inc · Stuart, FLBuilt 1974 · S/N 17262952 N1369BFryt Michael J · Goldsboro, NCS/N 371-72 N1369JWalsh Mark · Andover, MABuilt 1975 · S/N 369 N1369RRyals Jon Harris · Billings, MTBuilt 1975 · S/N AA5-0769 N1369TWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 34-7250301 N136ACPreacher John R · Jackson, GAS/N 673-92 N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004 N136BCBounds Robert E · Seward, NES/N 01 N136BDBrodersen Steve A · Lexington, KYBuilt 2007 · S/N 80264 N136CCShelk John Brian · Bend, ORBuilt 2002 · S/N 9953CC N136CHHall Kenneth C · Kernersville, NCBuilt 2004 · S/N 449 N136DKReece Robert B · Halstead, KSBuilt 2003 · S/N 24654 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N136EJForeman Guy W · Valparaiso, INBuilt 1979 · S/N 38-79A0572 N136FSale Reported · Broomfield, COSale reportedBuilt 2001 · S/N 60300 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N136HKuether Daniel D · Norfolk, NEBuilt 1999 · S/N 1091-1 N136HAEnstrom Helicopter Corp · Menominee, MIBuilt 2015 · S/N 2143 N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N136MMMiller Carl A · Vero Beach, FLBuilt 1993 · S/N 21718 N136MSTerhune Jack E · Alzada, MTBuilt 2015 · S/N 138 N136RCCaldwell Richard A · Indn Hbr Bch, FLBuilt 2000 · S/N 24187 N136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 10164 N136TRRv6a136tr LLC · Merrillville, INBuilt 2000 · S/N 34132 N136VPWartman Steven · Sandia Park, NMBuilt 1965 · S/N 28-21128 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953

Back to AD 90-04-06 R1