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.

N363CKAviator Air Operations LLC · Grand Prairie, TXBuilt 2004 · S/N 172S9634 N363CPBarr Air Patrol LLC · Mesquite, TXBuilt 2000 · S/N 172S8382 N363CS3tr Aviation LLC · Longview, TXBuilt 2022 · S/N 18283163 N363DSDonkers Dave · Nerstrand, MNBuilt 2003 · S/N 40.303 N363FSMarlu Enterprises Inc · Foristell, MOBuilt 1999 · S/N 23049C N363GCPorter David R · Dayton, OHBuilt 1993 · S/N 363 N363KRegistered aircraftBuilt 2018 · S/N 172S12195 N363MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881653 N363RJJordan Robert A · Avon Park, FLBuilt 2003 · S/N 363 N363RSOgden Laurence B · Weaverville, NCBuilt 1983 · S/N E3B-360 N363RVRoberts David · Albuquerque, NMBuilt 2010 · S/N 60388 N363SKKamasano LLC · Highland, CABuilt 2011 · S/N 2164 N363SPOrange County Flight Center Inc · Santa Ana, CABuilt 2001 · S/N 172S8781 N363TGGautier Thomas N III · Altadena, CABuilt 2017 · S/N 40363 N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511 N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636 N3640MDeaton Mark A · Gig Harbor, WABuilt 1947 · S/N 12-2495 N3640NShaikh Samir K · Schaumburg, ILS/N 680021 N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253 N3640XDoerhoff Daniel L Trustee · Lone Jack, MOBuilt 1969 · S/N 348 N3640ZElliott Frank F · Mojave, CABuilt 1960 · S/N 22-7535 N36411Runsick Michael C · Wynne, ARBuilt 1973 · S/N 273-73 N36412Martinsen John James · Aberdeen, WABuilt 1973 · S/N 970-73 N36413Steward James D · Monument, COBuilt 1973 · S/N 109-73 N36414Dewitt Elvin H · Santa Monica, CABuilt 1973 · S/N 390-73 N36417Huber Weylin L · Aberdeen, SDBuilt 1973 · S/N 575-73 N3641BUnity Aero Of Delaware LLC · Dover, DEBuilt 1980 · S/N 61P08148063424 N3641CFeldmann D Joshua · Epworth, IABuilt 1978 · S/N R18200290 N3641MSweet Water Air LLC · Kissimmee, FLBuilt 1978 · S/N 32-7840068 N3641NVilliger Arnold H · Henry, ILBuilt 1967 · S/N 680022 N3641RGeorge Walker Field Inc · Bedminster, NJBuilt 1969 · S/N 28-5737 N3641SHolzsweig Leon G · Dallas, TXBuilt 1980 · S/N 61P08178063426 N3641WMitchell Jeffrey Scott · Donalsonville, GABuilt 1966 · S/N 32-544 N3641YVictoria Jet Aviation LLC · Victoria, TXBuilt 1980 · S/N 61P08218063430 N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514 N3642MCraig James P · Jacksonville, ARBuilt 1947 · S/N 12-2497 N3642PSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1955 · S/N 22-3393 N3642QPorte Elvis · Miami, FLS/N MB-262 N3642WMasia Matt D · Paso Robles, CABuilt 1966 · S/N 32-545 N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73 N36438Dorman Richard E · Mesa, WABuilt 1973 · S/N 577-73 N3643DNevins Robert · North Palm Beach, FLBuilt 1981 · S/N 6008358161238 N3643MKing Jay M · King Salmon, AKS/N 12-2496 N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023 N3643TBds Flyer LLC · Middletown, DEBuilt 1981 · S/N 6008998161255 N3643XBurbey Mark G · Racine, WIS/N 301 N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663 N3644PHanselmann Seth · Lincoln, VTFirst renewal noticeBuilt 1955 · S/N 22-3395 N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742 N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516

Back to AD 81-18-04 R2