Skip to content

Registered aircraft · 81,733

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.

N34300Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 177RG0988 N34302Romero John M · College Station, TXBuilt 1972 · S/N 17701757 N34308Greenwood Kevin · Tucson, AZBuilt 1972 · S/N 17701759 N3430NKellner Darlene D · Lancaster, PABuilt 1967 · S/N 680050 N3430PChamberlain Paul E · Troup, TXBuilt 1958 · S/N 23-1396 N3430TMeador Phillips H · Lexington, KYBuilt 1968 · S/N 17700730 N3430WHerring Taylor R · Laredo, TXBuilt 1966 · S/N 32-291 N34316Dane Ward LLC · Rising Fawn, GABuilt 1972 · S/N 17701764 N34320Eagle Sky Patrol Inc · Deadwood, SDBuilt 1972 · S/N 17701766 N34328Hamilton Thomas Arden · Lovettsville, VABuilt 1972 · S/N 17701767 N3432AHolbrook Joel P · Delta Junction, AKBuilt 1953 · S/N 22-1699 N3432KPorte Elvis · Miami, FLBuilt 1967 · S/N 28-23552 N3432MSears Megan · Rigby, IDBuilt 1977 · S/N 28-7816343 N3432WNunak Air Taxi LLC · Kenai, AKBuilt 1966 · S/N 32-329 N3433CDiaz James R · Sullivan, OHS/N 26476 N3433MDixon Tom N · Lodi, CABuilt 1947 · S/N 12-2270 N3433PBolgar Mark S · Ewing, NJBuilt 1999 · S/N 420-99 N3433XRundus Timothy A · Chandler, AZBuilt 1966 · S/N 1125 N3433ZKitchen Ronald L · Leasburg, MOFirst renewal noticeBuilt 1960 · S/N 22-7347 N34343Wright Wayne M · Chestertown, MDBuilt 1972 · S/N 17701772 N34346Ball Donald · Hatfield, PABuilt 1972 · S/N 17701774 N34348Pingree Properties LLC · Hampshire, ILBuilt 1972 · S/N 17701775 N3434PNasair LLC · Flower Mound, TXBuilt 1958 · S/N 23-1401 N3434XAronhalt Daniel E · Columbus, INBuilt 1966 · S/N 1126 N34358Leap Aviation Inc · Wilmington, DEBuilt 1972 · S/N 17701777 N3435EBober Aviation Mountain Flying LLC · Hayesville, NCBuilt 1978 · S/N 17271547 N3435MJanson Matthew G · Midland, MIBuilt 1947 · S/N 12-2273 N3435NBailey Robert B · Damascus, ORBuilt 1967 · S/N 680052 N3435XYeaw Norman E · Hazel Green, ALBuilt 1966 · S/N 670032 N3436FChinik James G · Jacksonville Beach, FLBuilt 1967 · S/N 17700604 N3436RGressly Aviation LLC · Camp Verde, AZS/N 28-5680 N3436WIsland Aviation Management LLC · Plainview, NYBuilt 1966 · S/N 32-297 N3436XWebb Chris · Burns, TNBuilt 1966 · S/N 3403 N3436ZRasch Bernard A · Benton City, WABuilt 1960 · S/N 22-7351 N34378Johnston Paul · Belleville, MIBuilt 2021 · S/N 47P-129P/130P-P130P N3437M7550g LLC · Birmingham, MIBuilt 1977 · S/N 28-7890301 N3437TRoberts John M · Mansfield, MOBuilt 1968 · S/N 17700737 N3438MClark Stanley E Trustee · Redmond, ORBuilt 1947 · S/N 12-2276 N3438NDurst Luke · Panhandle, TXBuilt 1967 · S/N 680053 N3438SAvco Patrol LLC · Lyndon, KSBuilt 1972 · S/N 17701784 N3438WBlue Wanderers · Fort Wayne, INBuilt 1966 · S/N 32-302 N3439ASellers William R · Parker City, INBuilt 1953 · S/N 22-1707 N3439MRetzlaff Chris · Ripon, WIBuilt 1947 · S/N 12-2279 N343ABurleson Steven L · Las Vegas, NVBuilt 2007 · S/N 7224 N343AAAnding Paige E · Bryan, TXBuilt 1963 · S/N 18-7947 N343ACRegistration Pending · Campbellsburg, KYRegistration pendingBuilt 1999 · S/N 404-99 N343ASSilberman Allen · West Chester, PABuilt 1992 · S/N WM-2 N343BRendzio Robert J · Dothan, ALS/N TD-2 N343BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 2881651 N343CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283310

Back to AD 81-18-04 R2