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.

N25184Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13378 N25186Soule Raymond · Wiscasset, MES/N 1156 N25187Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13379 N25188Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13380 N25189Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13381 N2518ARegistration Pending · Wasilla, AKRegistration pendingBuilt 1953 · S/N 18-2148 N2518FWill Larry P · Fort Collins, COBuilt 1966 · S/N 136 N2518GVintage Aviation Inc · Garden City, NYBuilt 1967 · S/N 166 N2518LKerber John · Decorah, IABuilt 1979 · S/N 38-79A0749 N2518PRife Ramon K Jr · Casper, WYBuilt 1954 · S/N 22-2383 N2518UMitchell Daniel S · Shavano Park, TXBuilt 1979 · S/N 28-8016027 N2518ZAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 616-77 N25190Wiley Calvin B · Summer Shade, KYBuilt 1940 · S/N 1011 N25191Textron Aviation Inc · Wichita, KSBuilt 2025 · S/N 172S13382 N25194Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13383 N25199Career Track 5 LLC · Wilmington, DEBuilt 2025 · S/N 172S13384 N2519BWagner Douglas L · Newbury Park, CABuilt 1984 · S/N 830 N2519PDayton Dean W · Marysville, OHBuilt 1955 · S/N 22-2881 N2519QWhite Shane A · Fayetteville, GABuilt 1991 · S/N 1155 N2519TDouglas James E · Fallbrook, CAS/N 949 N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194 N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77 N251AGHays Cory W · Beaumont, TXFirst renewal noticeBuilt 1976 · S/N 0001 N251AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13262 N251BDWheatly Andy · Hedley, TXBuilt 2006 · S/N 4045 N251CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13086 N251DBSnoopys Air Service LLC · Wappingers Falls, NYBuilt 1968 · S/N 28R-30426 N251DMBandt Johnathan Paul · South Milwaukee, WIBuilt 2000 · S/N 1284-99 N251DYYbarra Daniel T · Westcliffe, COBuilt 2026 · S/N 42687-1 N251EARegistered aircraftBuilt 1969 · S/N 27-4238 N251EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13285 N251GJendair LLC · New York, NYBuilt 1977 · S/N 61P-0462-181 N251HFHaidar Aviation LLC · Dallas, TXBuilt 2025 · S/N JP001 N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124 N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21 N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003 N251MECavu Aircraft Group LLC · Green Cove Springs, FLBuilt 2000 · S/N 18280740 N251MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881443 N251NDKasowski Flint · Buffalo, NDBuilt 1998 · S/N 2842042 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N251RBNewton Roger N Jr · Marrero, LABuilt 1984 · S/N 408 N251RGBunn Mary · Williamstown, WVBuilt 2008 · S/N 089 N251RXPlane Therapy LLC · Hudson, FLBuilt 1978 · S/N AA5A0545 N251SFCgc Prop Plane 1 LLC · Metairie, LABuilt 2025 · S/N 172S13444 N251TGelvin Stanley M · Central, AKBuilt 1946 · S/N 12-254 N251TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020241 N251TTTyson David · Lusk, WYBuilt 1997 · S/N 25013C N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000 N251WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 287990548 N251WHTallmadge Brian · Prescott, AZBuilt 1994 · S/N 3251

Back to AD 81-18-04 R2