Skip to content

Registered aircraft · 20,683

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N7226GHerlihy Douglas K II · Denville, NJBuilt 1970 · S/N 17258926 N7226TCreasman Zane V · Arden, NCBuilt 1959 · S/N 46826 N7227ANewman Christan C · Niota, TNBuilt 1956 · S/N 29327 N7227GBeltz Richard D · Lehighton, PABuilt 1970 · S/N 17258927 N7227QElite Air LLC · Tullahoma, TNBuilt 1972 · S/N 17260527 N7228APaine Jered J · Cashmere, WAFirst renewal noticeBuilt 1956 · S/N 29328 N7228GFasking Dan · Stanford, ILS/N 17258928 N7229ASale Reported · Belleville, ILSale reportedBuilt 1956 · S/N 29329 N7229QSwitzer Frank Jr · Port Allegany, PABuilt 1972 · S/N 17260529 N7229TSmith Carl L · Vinita, OKS/N 46829 N722AARobinson Charles F Jr · Portage, MIBuilt 1972 · S/N 17261274 N722EFEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12824 N722HGAmeriflyers Of Florida LLC · Addison, TXBuilt 1998 · S/N 17280402 N722LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13199 N722MAK2 Aviation LLC · Greenwood Village, COBuilt 2013 · S/N 172S11324 N722SAElmendorf Afb · Elmendorf Afb, AKS/N 17280026 N7230GMaples Kevin T · Pueblo, COS/N 17258930 N7230QArcade Flying Club Inc · El Dorado Hills, CABuilt 1972 · S/N 17260530 N7231QDsr-Cherokee 180 LLC · Dallas, TXS/N 17260531 N7232ABakunova Eugenia S · Cordova, AKBuilt 1956 · S/N 29332 N7234AMoore Thomas K · Pleasant View, UTBuilt 1956 · S/N 29334 N7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeBuilt 1970 · S/N 17258934 N7234QLavinio Stephen E · Southampton, NYBuilt 1972 · S/N 17260534 N7235GMcnair William H · Gold Beach, ORBuilt 1970 · S/N 17258935 N7236QTeren Nelson F · Friday Harbor, WABuilt 1972 · S/N 17260536 N7237GIvoprop Corp · Long Beach, CABuilt 1970 · S/N 17258937 N7237QMartin Bach Aviation LLC · Cornelius, NCBuilt 1972 · S/N 17260537 N7239AEasley Daniel W · Wasilla, AKBuilt 1956 · S/N 29339 N723CATextron Aviation Inc · Wichita, KSS/N 172S13636 N723GPuerta Jose Fernando Del Valle · Miami, FLBuilt 1976 · S/N 17268008 N723HGFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280408 N723LAGregg James H · Parkton, NCBuilt 1958 · S/N 36930 N723LCLudwig Robert P · Pflugerville, TXBuilt 1965 · S/N 17253332 N723LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13202 N723MDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13487 N723PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 17280675 N723SPElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8657 N7240AIrwin Timothy L · Cottonwood, AZBuilt 1956 · S/N 29340 N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940 N7241AGibbs Geoffrey M · Holland, TXS/N 29341 N7241TSelleck Philip A · Falls Church, VABuilt 1959 · S/N 46841 N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407 N7242GIrizarry Heriberto J · Homestead, FLBuilt 1970 · S/N 17258942 N7242TDenton David · Siloam Springs, ARBuilt 1959 · S/N 46842 N7243GKrumbine David A · Lebanon, PABuilt 1970 · S/N 17258943 N7244QBuckley Gregory L · Melba, IDS/N 17260544 N7244TFlood John M · Bozeman, MTBuilt 1959 · S/N 46844 N7245AStoup Kyle W · Foss, OKBuilt 1956 · S/N 29345 N7245TWestfall James H · Bend, ORBuilt 1959 · S/N 46845 N7246GHale Warren P · Martinsburg, MOBuilt 1970 · S/N 17258946

Back to AD 90-06-03 R1