Skip to content

Registered aircraft · 81,728

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N2470HKing Bruce J · Waldport, ORBuilt 1979 · S/N 18-7909192 N2470MFluckey Gary T · Homer, AKS/N 12-1551 N2470NAlpha International Aircraft Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 172S10187 N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334 N24718Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0002 N2471ARink Raymond E · Mimbres, NMBuilt 1952 · S/N 22-809 N2471DWestern Edge Aviation LLC · Dickinson, NDBuilt 2000 · S/N 18280892 N2471EWilliams Stephen H · Phoenix, AZBuilt 1982 · S/N 18268206 N2471LGuzman Gerald F · Winchester, CABuilt 1979 · S/N 38-79A0712 N2471NTwo Dot Aircraft LLC · Kalispell, MTBuilt 1979 · S/N 38-79A0859 N2471USchroeder Nyla R · Minneapolis, MNBuilt 1979 · S/N 28-8090049 N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341 N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969 N2472MAufderhar Kenneth G · Lopez Island, WABuilt 1947 · S/N 12-1692 N2472NVann Dudley C DBA · Greenville, NCBuilt 1979 · S/N 38-79A0860 N2472UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10074 N2472VColthirst Michael · Clarksville, TNBuilt 1982 · S/N 38-82A0064 N2473GFly For Fun Aircraft LLC · Baltimore, MDBuilt 2001 · S/N 17281019 N2473MMcgahan Jackie L · Kenai, AKBuilt 1947 · S/N 12-1690 N2473NKline Glenn A · Iron River, MIBuilt 1979 · S/N 38-79A0861 N2473PAnderson Tony V · Pendleton, ORBuilt 1955 · S/N 22-2848 N2473WCahill Chad · Edmond, OKBuilt 1985 · S/N 28-8590073 N2473YFunderburg Erskine R · Pell City, ALBuilt 1985 · S/N 28-8590074 N2473ZGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10082 N24748Delta State University · Cleveland, MSBuilt 2001 · S/N 17281051 N2474BLetourneau University · Longview, TXBuilt 1978 · S/N 38-79A0078 N2474CArchitectural Industrial Rentals LLC · Wilmington, DEBuilt 2001 · S/N 18280978 N2474FCoke Roger T · Clarksville, INFirst renewal noticeBuilt 1979 · S/N 38-79A0468 N2474GSchwartz Theodore Francis · Fogelsville, PABuilt 1979 · S/N 38-79A0541 N2474MAshe David J · Randle, WAS/N 12-1553 N2474PSeidel William G Jr · Poway, CABuilt 1955 · S/N 22-2849 N2474YLogan Air Services LLC · Logan, UTBuilt 2005 · S/N 172S10083 N2474ZTeufel Jeffrey · North Pole, AKBuilt 1954 · S/N 18-3592 N24752Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280355 N24756Wings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S10086 N2475ABowser Dwight H · Anchorage, AKBuilt 1952 · S/N 22-818 N2475LDeralex Airways LLC · Miami, FLBuilt 2001 · S/N 17280990 N2475MN B Tweet And Sons · Nome, AKBuilt 1947 · S/N 12-1688 N2475PErickson Scott L · Omaha, NES/N 22-2796 N2475TDurban George E · Indianola, IABuilt 1978 · S/N 38-78A0812 N24763Big South Fork Aerospace LLC · Pine Knot, KYBuilt 1977 · S/N 15280361 N24764Riya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280362 N24765Alpha Aircraft International LLC · Lake Worth, FLS/N 15280363 N24766Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280364 N24767Tennessee Technology Center At Morristown · Morristown, TNBuilt 1977 · S/N 15280365 N2476ESkyspot Advertising LLC · Lakeland, FLBuilt 2001 · S/N 172S8784 N2476GSouthern Region Machine Service Inc · Castlewood, VABuilt 1979 · S/N 38-79A0542 N2476JCrosshares Aircraft Holdings LLC · Plymouth, INBuilt 2001 · S/N 172S8785 N2476MPremier Flight Center LLC · Hartford, CTBuilt 1977 · S/N 28-7816286 N2476NHart Lewis W DBA · Rexburg, IDBuilt 1979 · S/N 38-79A0862

Back to AD 81-18-04 R2