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.

N38267Andy Mack Management LLC · Wilmington, DEBuilt 1977 · S/N 28-7716237 N3826MBaugh Caleb · Carthage, MOBuilt 1947 · S/N 12-2568 N3826PBauries Brian W · Abilene, TXBuilt 1955 · S/N 22-3516 N3826WMiller Heather J · Dupo, ILBuilt 1966 · S/N 32-759 N3826ZWebster William S · Eden, WYBuilt 1961 · S/N 18-7569 N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086 N38276N38276 LLC · Las Vegas, NVBuilt 1977 · S/N 32-7740081 N3827MFox James Douglas · Pittsburg, ILBuilt 1978 · S/N 28-7890335 N3827TBrauer Noah J · Covington, KYBuilt 1967 · S/N 28R-30145 N3828PPupator Peter Trienko · Willow, AKBuilt 1955 · S/N 22-3518 N3828ZOrvin Sanden Inc · Wyndmere, NDBuilt 1960 · S/N 18-7571 N38291Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716240 N38293L & A Bennett Second Family L P · Renton, WAS/N 28-7790537 N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087 N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929 N3829TFreese Pamela L · Frederic, WIBuilt 1967 · S/N 28R-30147 N3829XFerrari Martin · Centerville, OHBuilt 1981 · S/N M-2306 N382AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281192 N382ASAero Leasing · Brookings, ORBuilt 1998 · S/N 2902 N382BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010086 N382CCVeenstra Timothy S · Wasilla, AKS/N 9946CC N382CFTurner Noah S · Gilbert, AZBuilt 1979 · S/N 38-79A1043 N382CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282461 N382DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843845 N382DFDream Flight LLC · Westminster, MDBuilt 1976 · S/N 17268233 N382DPBurns Craft LLC · Wilmington, DEBuilt 1971 · S/N MSA115001 N382JNSilver Sky Air LLC · Fresno, CABuilt 1973 · S/N 17262794 N382JSDap Aviation Ventures LLC · Missoula, MTBuilt 2021 · S/N 18283156 N382MAFly To Sea LLC · Stanford, CABuilt 2004 · S/N 487-2004 N382NHendren Ronald P · Clarkston, MIBuilt 1977 · S/N AA5A0519 N382NDUniversity Of North Dakota · Grand Forks, NDBuilt 2024 · S/N 2881828 N382PTTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 38-78A0003 N382SJAerospace Museum Of California · Mcclellan, CABuilt 1967 · S/N DMR-1 N382XAnderson David C · Dilley, TXBuilt 1976 · S/N 7021C N383Martis Valley Aviation LLC · Redwood City, CABuilt 1981 · S/N ME-388 N38305Wulf Aerospace LLC · Santa Rosa Beach, FLBuilt 1977 · S/N 32R-7780413 N3830PHeckerman Ted A · Canyon Lake, TXBuilt 1955 · S/N 22-3520 N3830QAero Place Flyers Inc · Urbana, ILBuilt 1971 · S/N 17259930 N3830TStevenson Shane C · Sicklerville, NJBuilt 1967 · S/N 28R-30148 N3830WKris Noone Air LLC · Wilmington, DES/N 32-764 N38311Archair Enterprises Inc · Wilmington, DEBuilt 1977 · S/N 28-7790538 N38312Barnes Carl A · Jacksonville, FLS/N 28-7725261 N38313Lwr LLC · Teton, IDBuilt 1977 · S/N 28-7725262 N38315Meyer Lynn O · Olathe, KSBuilt 1977 · S/N 28-7725275 N38316Meriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7716241 N38319Fronduto Cody Michael · Fort Pierce, FLBuilt 1977 · S/N 28-7790539 N3831MWebster Mark A · Chino Hills, CABuilt 1978 · S/N 28R-7837138 N3831PPerkins Jason T · Hudson, MEBuilt 1955 · S/N 22-3521 N3831ZFloats N Hoes LLC · Umatilla, FLBuilt 1961 · S/N 18-7574 N38324De Oliveira Antonio J · Fuquay Varina, NCBuilt 1977 · S/N 28-7790535

Back to AD 81-18-04 R2