Skip to content

Registered aircraft · 2,861

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:97-05-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1') 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:97-05-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1')
  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:97-05-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-05-03-R1')
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.

N3019VTimmons Mark M · New Port Richey, FLBuilt 1947 · S/N D-423 N301EWAery Aviation LLC · Wilmington, DEBuilt 1980 · S/N 309 N301NAAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1979 · S/N 232 N3021VMunoz Pedro L · Ontario, NYBuilt 1947 · S/N D-425 N302SJSendero Aviation LLC · Houston, TXBuilt 1979 · S/N 550-0052 N302WCCst Management LLC · Pflugerville, TXBuilt 1995 · S/N 560-0329 N303CPDjh1 LLC · Liberty Township, OHBuilt 2000 · S/N 560-0539 N303HCN303hc LLC · Amarillo, TXBuilt 1998 · S/N 560-0460 N303KMCoastal Rentals LLC · Allen, KYBuilt 2000 · S/N 525-0180 N303MPAir Cargo Services LLC · Miami, FLS/N 390 N3041VGood Brian L · Wildomar, CABuilt 1947 · S/N D-448 N304BPIntermountain Air Inc · Colorado Springs, COBuilt 2019 · S/N 525-1017 N30501Dutchess Community College · Poughkeepsie, NYS/N 383 N3056VMinneman Alan R · Jefferson, TXBuilt 1947 · S/N D-469 N305LRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1980 · S/N 305 N305ZPLewis Aviation LLC · Baton Rouge, LABuilt 1997 · S/N 550-0819 N3061VRegistration Pending · Amboy, INRegistration pending, pending cancellationBuilt 1947 · S/N D-474 N3064VLehmann Mark C · Trade, TNS/N D-478 N3065VEvans Bruce E · Aztec, NMBuilt 1947 · S/N D-479 N3068VBurgin Lee · Borger, TXS/N D-482 N3074VHancock Steven W M · Bristow, VABuilt 1947 · S/N D-488 N307XPSkybridge Aviation Group Inc · Apopka, FLBuilt 1996 · S/N 258307 N3083VAnderson Charles E · Fort Worth, TXBuilt 1947 · S/N D-498 N3088VStartz John D · Dallas, TXBuilt 1947 · S/N D-504 N3089VMaximus Aviation LLC · Cheyenne, WYBuilt 1947 · S/N D-505 N308CMCattlemen Logistics LLC · Minden, NEBuilt 2023 · S/N 525-1156 N308DD225sbi LLC · Stuart, FLBuilt 2004 · S/N 258665 N308DTTippmann Industrial Products Inc · Fort Wayne, INBuilt 2004 · S/N 550-1094 N308NJ22ase LLC · Aspen, COS/N 525-0912 N308TWCentral Connecticut Aircraft LLC · Plainville, CTBuilt 1979 · S/N 550-0044 N3093VBeavers Charles M · Rockmart, GABuilt 1947 · S/N D-510 N3096VNovak Warren Devereaux Grey · Lake Placid, FLBuilt 1947 · S/N D-513 N30AVExtraordinaire Aviation LLC · Fairfield, OHS/N 550-0026 N30BPLkh Group LLC · Naples, FLBuilt 2014 · S/N 525-0816 N30CVTweety Bird LLC · Henderson, NVBuilt 1991 · S/N 560-0150 N30GRGreat Ride LLC · Meridian, MSS/N 550-0656 N30HEClassic Aircraft Aviation Museum Inc · Hillsboro, ORBuilt 1967 · S/N 51 N30KMRefreshed 0110 LLC · Dover, DEBuilt 2021 · S/N 525-1073 N30LAAerokb LLC · Wilmington, DEBuilt 1993 · S/N 5250041 N30LXN492a LLC · Goodyear, AZBuilt 1984 · S/N 438 N30MSkysouth Aviation Inc · Durham, NCBuilt 2003 · S/N 525-0506 N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225 N30NMTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1420 N30NSHilltop LLC · Rye, NYBuilt 2014 · S/N 525-0835 N30RLRomeo Tango Aviation LLC · Rockford, ALBuilt 1990 · S/N 550-0653 N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152 N30TKGravitas Aero LLC · Dallas, TXBuilt 1982 · S/N 374 N30VRWd Journeys Inc · Downers Grove, ILBuilt 2002 · S/N 5250481 N30WRInfotech Management Inc · San Diego, CANon-citizen corporation, flight hours not reportedBuilt 1983 · S/N 380 N3101VWallace William D · Brunswick, GABuilt 1947 · S/N D-520

Back to AD 97-05-03 R1