Skip to content

Registered aircraft · 6,916

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-01-01-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-01-01-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-01-01-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-01-01-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-01-01-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-01-01-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.

N7480PDavenport Jimmy J · Hayesville, NCS/N 24-2673 N7481JShaffer John W · Titusville, PABuilt 1968 · S/N 28R-30839 N7482PN9246k Corp LLC · Federal Way, WABuilt 1961 · S/N 24-2675 N7485PE R V Air LLC · Jacksonville, FLBuilt 1961 · S/N 24-2678 N7485YCline Aircraft LLC · Mena, ARBuilt 1964 · S/N 30-546 N7486PMakee Markus J · Painesville, OHBuilt 1961 · S/N 24-2679 N7486YGardner Canaan · Chandler, OKBuilt 1964 · S/N 30-547 N7487PShockley Lee W · Denver, COBuilt 1961 · S/N 24-2680 N7488P2final LLC · Leesburg, VABuilt 1961 · S/N 24-2681 N7489JMayer Thomas D · Medford, ORBuilt 1968 · S/N 28R-30849 N7489PRegistration Pending · Whitefish, MTRegistration pendingBuilt 1961 · S/N 24-2682 N7490PRobinson John W · Ten Mile, TNBuilt 1961 · S/N 24-2683 N7492JClassic Air Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30852 N7492PCache Rentals 401k P.S.P. · Greeley, COS/N 24-2686 N7493JRegistered aircraftBuilt 1968 · S/N 28R-30854 N7493PBassar Michael · Eagle, MIBuilt 1961 · S/N 24-2687 N7494PM And P Aviation Inc · Albia, IABuilt 1961 · S/N 24-2689 N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555 N7495JDreamair LLC · Fargo, NDBuilt 1968 · S/N 28R-30856 N7495PSale Reported · Fort Lauderdale, FLSale reported, pending cancellationBuilt 1961 · S/N 24-2690 N7496PS & S Air Inc · Wilmington, DEBuilt 1961 · S/N 24-2691 N7497PLift Aircraft LLC · Carmel, INBuilt 1961 · S/N 24-2692 N7498JSawyer Steven A Md · Hampton, GABuilt 1968 · S/N 28R-30860 N7498PKarnegis Frank J · Senoia, GABuilt 1961 · S/N 24-2693 N7499PTri-C Farms · Tompkinsville, KYBuilt 1961 · S/N 24-2696 N749CSBower John M · Santa Cruz, CABuilt 1976 · S/N 28R-7635222 N749LWLease One LLC · Lafayette, INBuilt 1977 · S/N 347770416 N74BNBig Bend Community College Foundation · Moses La, WABuilt 1969 · S/N 30-1806 N74MPRegistration Pending · Bargersville, INRegistration pendingS/N 34-7770194 N74YCButzer Brian K · Boca Raton, FLBuilt 1969 · S/N 30-1847 N7500JNour George E · Eatonton, GAS/N 28R-30863 N7500PBas Part Sales LLC · Greeley, COBuilt 1961 · S/N 24-2699 N75014Hammonds Hangars Inc · Wilmington, DEBuilt 1976 · S/N 32R-7680246 N7501JSholl Douglas Alan Jr · Williams, AZBuilt 1968 · S/N 28R-30864 N7502JIrvin H Hugh · Salina, KSBuilt 1968 · S/N 28R-30866 N75034Rpm Aviation LLC · Hillsborough, NCBuilt 1976 · S/N 32R-7680248 N7503PHouseth Timothy C · Hastings, MNBuilt 1961 · S/N 24-2704 N7503YCunneen Sean M · Vista, CABuilt 1964 · S/N 30-565 N75046Esson Michael · Durand, MIS/N 28R-7635261 N75050Delaware State University · Dover, DEBuilt 1976 · S/N 28R-7635262 N75091Pettet David · Brook, INBuilt 1976 · S/N 32R-7680256 N7509PSuperbird Aviation LLC · Atlantic, IABuilt 1961 · S/N 24-2710 N750HKRegistration Pending · Lutz, FLRegistration pendingS/N 30-947 N7510JArmstrong Craig V · Casstown, OHBuilt 1968 · S/N 28R-30876 N7510PMavco Corp · Lewes, DEBuilt 1961 · S/N 24-2711 N75120Kratzer Edgar · New Port Richey, FLBuilt 1976 · S/N 34-7670224 N75127Amob 2 LLC · Baton Rouge, LABuilt 1976 · S/N 28R-7635267 N7512JInfinity Aviation Group LLC · Nashua, NHS/N 28R-30879 N75130Tack Charles D · Apollo Beach, FLBuilt 1976 · S/N 32R-7680262 N7513JHenslin Maja Blu · Wyoming, MNBuilt 1968 · S/N 28R-30880

Back to AD 97-01-01 R1