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.

N4VHFoster Chad H Jr · Uvalde, TXBuilt 1977 · S/N 421C0435 N5005JDowding Industries Inc · Eaton Rapids, MIBuilt 1974 · S/N 310R0129 N500AWMcnulty Kim E · Tehachapi, CAS/N 310R0077 N500CHAchiro David P · Truckee, CABuilt 1976 · S/N 310R0734 N500TJAirbyars LLC · Spartanburg, SCBuilt 1974 · S/N 421B0585 N502ATAir Note LLC · Delray Beach, FLBuilt 1973 · S/N 421B0547 N502SAZambrano Homero Ramones · Bulverde, TXBuilt 1978 · S/N 421C0520 N5037JWoodland William B · Anchorage, AKS/N 310R0733 N5038JKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 310R0158 N503NAClover Park Technical College · Lakewood, WAS/N 402B-0313 N5047JAir Transport Arm Of Christ Inc · Hurst, TXBuilt 1975 · S/N 310R0167 N5057JTopliff John G · Goodland, KSS/N 310R0177 N505LTLaufer Air Inc · Hartford, WIBuilt 1978 · S/N 421C0617 N505RWCor Group LLC · Arlington, WAS/N 421B0268 N5072CThomas Robert Allan Jr · Phoenix, AZBuilt 1978 · S/N 310R1414 N5083JKrs Aerial Inc · Galloway, OHS/N 310R0203 N50DLSand Castle Management LLC · Wichita, KSBuilt 1973 · S/N 421B0526 N50LWildcat Aeroplanes LLC · Sedalia, COBuilt 1977 · S/N 421C0431 N50ZPPalen Mark T Trustee · Cleveland, TNBuilt 1975 · S/N 421C0022 N510SMGolden Leaf Tobacco Company Inc · Keysville, VAS/N 421C0112 N5111JValiair Ltd Co Trustee · Casper, WYBuilt 1975 · S/N 310R0231 N513FSJackson Construction Services LLC · Wichita Falls, TXS/N 421C0510 N513JNFly Area LLC · Charleston, SCS/N 421C0293 N513SJWagner Distributing Co Inc · Auburn, CABuilt 1975 · S/N 421C0043 N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104 N518BBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 421B0518 N51QZAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1982 · S/N 421C1237 N520ABGolden Eagle Transportation LLC · Lafayette, LABuilt 1979 · S/N 421C0690 N521ADBarringer Aviation LLC · Waxhaw, NCBuilt 1977 · S/N 310R0966 N521RMHeal Ray · Denton, TXBuilt 1977 · S/N 421C0335 N5251CSherman Randolph · Beverly Hills, CABuilt 1978 · S/N 310R1526 N5251JNarr Craig S · Fort Mohave, AZBuilt 1976 · S/N 310R0813 N5255CMcintosh Law Corp · Long Beach, CABuilt 1978 · S/N 310R1528 N525SFPrimrose LLC · Columbus, NEBuilt 1976 · S/N 421C0080 N5288JOsborne Mobile Home Park LLC · North Little Rock, ARBuilt 1976 · S/N 421C0158 N528TWEnviro Vat Lp · Midland, TXBuilt 1980 · S/N 421C1032 N52JVSl Leasing Group LLC · Atlanta, GABuilt 1973 · S/N 421B0459 N530DMBorders Nowell · Edinburg, TXS/N 421B0839 N5337CMarc Inc · Bolton, MSBuilt 1978 · S/N 310R1543 N5355JRusty Simpson LLC · Nemo, TXS/N 421C0669 N5370JJaaam Skyline Inc · Middletown, DEBuilt 1975 · S/N 421B0920 N5371JColeair LLC · Lewes, DEBuilt 1975 · S/N 421B0921 N5397JCp Aviation LLC · Washington, DCBuilt 1975 · S/N 421B0947 N53MG28 Lv LLC · Las Vegas, NVBuilt 1980 · S/N 421C0909 N53MJAviation Hangar Foam Specialists LLC · Tucson, AZBuilt 1979 · S/N 421C0667 N53RRTwo Romeos LLC · Pasco, WAS/N 421A0029 N540CASpradlin Flying Service Inc · Petersburg, TXBuilt 1976 · S/N 421C-0144 N540CCAndriopulos Salguero Inc · Hialeah, FLS/N 421C0675 N5417CExecutive Aircraft Management Services LLC · Pompano Beach, FLS/N 421C0012 N5421FAlvey Chad R · Bargersville, INBuilt 1979 · S/N 421C0660

Back to AD 75-23-08 R5