Skip to content

Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N4811TDill Mark B · Neosho Rapids, KSS/N 32-7240086 N481TCFargo Aviators LLC · Phoenix, AZBuilt 2002 · S/N T18208184 N481WPoper Jeremy · Albuquerque, NMBuilt 2005 · S/N T18208362 N4824WFmp Properties LLC · Joplin, MOBuilt 1976 · S/N 14154 N4826WRoss Steve M · Marion, ILBuilt 1976 · S/N 14156 N482CGKilo Sierra Enterprises LLC · Lafayette, COBuilt 2005 · S/N T18208438 N482DRThurston Steven Curtis · Salisbury, NCBuilt 1977 · S/N 32R-7780391 N482RPPlane Robert A · Harvard, ILBuilt 1976 · S/N 14155 N4830WCaliguire Michael R · Easton, PABuilt 1976 · S/N 14160 N4832WDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14162 N4837WFields Joseph H · Placerville, CABuilt 1976 · S/N 14167 N4843WMcclean Matthew James · Springfield, MOBuilt 1976 · S/N 14173 N4845FMattern Jeffrey A · Brunswick, OHBuilt 1976 · S/N 32R-7680482 N4846WPrice David · Loudon, TNS/N 14176 N4847WIskin Jeffrey Trustee · Concord, CABuilt 1976 · S/N 14177 N484APDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 32-8124003 N4850WWilliams Edward · Hayward, CABuilt 1976 · S/N 14180 N4851FRagland Brady J · Amarillo, TXBuilt 1976 · S/N 32R-7680483 N4855PAvenger Aviation LLC · Midland, TXBuilt 2004 · S/N T18208337 N4856WUhl John W · Sellersburg, INBuilt 1976 · S/N 14186 N4857WShelor Christina L · Virginia Beach, VABuilt 1976 · S/N 14187 N4869BSchaffer Brandon T · Vlg Of Lakewd, ILBuilt 1984 · S/N 32-8424002 N4872SBlocker James Deric · Cave Creek, AZS/N 32-7140054 N4876SLedford Roland S · Borger, TXBuilt 1971 · S/N 32-7140057 N488ATParks Vernon L · Houston, TXBuilt 1991 · S/N 27-0088 N4892SF&G Polk Aviation LLC · Babson Park, FLBuilt 1971 · S/N 32-7140058 N4895WTaylor Mark W · Amherst, NYBuilt 1977 · S/N 14225 N4897WGibson Kurt A · Fort Smith, ARBuilt 1977 · S/N 14227 N48BLNw Aircraft Sales & Leasing LLC · Scappoose, ORBuilt 1992 · S/N 0019 N48TNWest Thomas L · Payson, AZBuilt 1975 · S/N 60-0214-094 N48YKimble Robert · Marco Island, FLBuilt 1981 · S/N 27-8154022 N4911W3js Aviation LLC · Wilmington, DEBuilt 1977 · S/N 14235 N491JGHartwig Farms LLC · Excelsior Springs, MOBuilt 2001 · S/N T20608265 N4921WForward Aero LLC · Thomasville, PABuilt 1977 · S/N 14245 N4927FRegistered aircraftBuilt 1976 · S/N 32R-7680489 N4928WL D Aviation LLC · Chesapeake, VABuilt 1977 · S/N 14251 N492AGBounds Lee S · Pflugerville, TXS/N 32-40228 N492BCConsumer Collection Management Inc · Saint Louis, MOBuilt 2005 · S/N 3255037 N4931WPerry Clifton · Lacon, ILBuilt 1977 · S/N 14254 N4934WS&T Aircraft LLC · Lewes, DEBuilt 1977 · S/N 14256 N4942FBarton Investment LLC · Salt Lake City, UTBuilt 1976 · S/N 32R-7680490 N4947FKpw Enterprises Inc · Chula Vista, CABuilt 1976 · S/N 32R-7680492 N494MBMulhearn Walter F · Conroe, TXBuilt 1980 · S/N 32R-8029056 N495JBVan Bortel Aircraft Inc · Arlington, TXBuilt 2004 · S/N T18208284 N495WFWalters Steven M · Marathon, FLBuilt 1995 · S/N 3213097 N4960250 Inc · Washington, DCS/N 24-4025 N4960FLc Aviation LLC · Fort Meade, FLS/N 32-7640123 N4966FDj&A Enterprises LLC · Sevierville, TNBuilt 1976 · S/N 32R-7680494 N4976WQualitair LLC Trustee · MichelstadtBuilt 1977 · S/N 14296 N4981WJahn Kenneth Kris · Shingle Springs, CABuilt 1977 · S/N 14301

Back to AD 91-21-01 R1