Registered aircraft · 999

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:75-23-08-R5') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-08-R5') 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:75-23-08-R5')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-08-R5')
  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:75-23-08-R5')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-08-R5')
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.

N5PJGod Family Ministries International Inc · Elmont, NYBuilt 1972 · S/N 421B-0258 N5UTK&L Salty Air LLC · Stephenville, TXBuilt 1976 · S/N 421C0101 N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007 N602DCKeystone Xpress LLC · Rostraver Twp, PAS/N 421C0864 N605DCT&C Aviators LLC · Green Cove Springs, FLS/N 421C-1005 N605SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 421C1041 N6098XKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1266 N60GMInternational Air Services Inc Trustee · Carson City, NVS/N 421C-0828 N610W610w Holdings LLC · Sandy, UTS/N 310R-0322 N6115CHat Investments LLC · Spartanburg, SCS/N 421C0890 N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293 N612CGCasa Grande Homes Inc · Blanchard, OKBuilt 1973 · S/N 421B0416 N6131XGv Air Inc · Medford, ORS/N 310R1296 N6161XGolden Eagle Aircraft LLC · Boulder, COS/N 421C0895 N616DFugate Kirk A · El Dorado Springs, MOS/N 421B0140 N6177XMayhew William D · Round Lake, ILBuilt 1978 · S/N 310R1316 N617CCRiley Livestock Inc · Mayfield, KYS/N 421C0897 N6192XSongbird Group LLC · Andover, MNBuilt 1978 · S/N 310R1329 N619ACFeed Yard Industrial Solutions LLC · Amarillo, TXBuilt 1977 · S/N 421C0336 N61AJCoco Air Ltd Trustee · Wilmington, DEBuilt 1978 · S/N 421C0457 N61JV61jv LLC · Chuckey, TNS/N 421C0097 N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858 N624CAClarke Cecil Jr Trustee · Katy, TXBuilt 1975 · S/N 402B0876 N624PKBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 421B0144 N626DRK And L Transportation LLC · Carterville, ILS/N 421C0512 N6272TBernaiche Travis · Caribou, MEBuilt 1969 · S/N 421A0141 N628RJJanak Jeffrey · Corpus Christi, TXBuilt 1974 · S/N 421B-0503 N629WMVortech LLC · Woodbury, NYS/N 421C1001 N62JCChuoke Joseph P · Texas City, TXS/N 421C0498 N630ADT Machine LLC · Livingston, MTBuilt 1977 · S/N 421C0406 N6315XEagle Aviation LLC · Morristown, TNBuilt 1981 · S/N 421C1003 N633MCSveen Jeffrey T · Aberdeen, SDBuilt 1979 · S/N 421C0657 N6375XMiliano Air LLC · Lewes, DEBuilt 1978 · S/N 402B1338 N6384XPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1978 · S/N 402B1347 N6387XAir Exec Inc · Mount Pleasant, IABuilt 1978 · S/N 402B1350 N6396XAviation Tech Services LLC · Edgewater, FLBuilt 1978 · S/N 402B1355 N639SCSale Reported · Glen Allen, VASale reportedBuilt 1969 · S/N 421A0102 N648SBHays Kelly · Dumas, TXBuilt 1979 · S/N 421C0648 N654DEDill Brice R · Glendale, AZBuilt 1978 · S/N 310R1428 N657WMRegistration Pending · Carlsbad, NMRegistration pendingS/N 421C0474 N6599GPremiere Aviation Inc · Concord, CAS/N 421C0275 N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408 N65AEMorris Charles J · Rutherford, TNBuilt 1975 · S/N 421B0953 N6633TC C I C Aircraft Division One LLC · Kalispell, MTBuilt 1977 · S/N 421C-0277 N664RJGeneva Lakes Aviation LLC · Lake Geneva, WIBuilt 1975 · S/N 402B0854 N664SKenney Michael D · Lucas, TXBuilt 1978 · S/N 421C0467 N6675QLoyal Aviation LLC · Loyal, WIBuilt 1973 · S/N 421B0442 N66CLLiberty Eagle LLC · Helena, MTBuilt 1980 · S/N 421C1019 N66EPSpillett James Kreg · Sandy, UTBuilt 1973 · S/N 421B0520 N676MFCoastal Resource Associates Inc · Christiansted, VIBuilt 1971 · S/N 402B0106

Back to AD 75-23-08 R5