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.

N712JWFalcon & Phoenix Aviation LLC · Las Vegas, NVBuilt 1969 · S/N 421A0128 N712SBSinger Nathan · Pismo Beach, CABuilt 1975 · S/N 310R0122 N7135GRegistered aircraftBuilt 1977 · S/N 421C0284 N71544Miller Family Enterprises LLC · Humble, TXS/N 421B0552 N716RMMattracks Promotions Inc · Karlstad, MNBuilt 1974 · S/N 421B-0528 N717LRJnnss LLC · Hillsborough, NJS/N 421C1109 N717TVPinkert Sy · Silverthorne, COBuilt 1978 · S/N 310R1341 N71JRSouthgate Development Inc · Wichita Falls, TXBuilt 1976 · S/N 421C0066 N72053South Aircraft Leasing Inc · Wilmington, DEBuilt 1974 · S/N 402B-0587 N720FSVero Executive Flyers Inc · Fort Pierce, FLS/N 421C1250 N721HBBrazilco Aviation LLC · Missouri City, TXS/N 421C0629 N721VGB & W Aerial Spray Inc · Dimmitt, TXS/N 421B0847 N723ESEs Owens LLC · Mustang, OKBuilt 1982 · S/N 421C1217 N726LAValiair Lc Trustee · Casper, WYBuilt 1974 · S/N 421B0651 N726RTCrotts Aircraft Service Inc · Dodge City, KSBuilt 1976 · S/N 421C0087 N727ESHoover421 LLC · Rockport, TXBuilt 1977 · S/N 421C0268 N728SCQuist David Andrew · Lake Jackson, TXS/N 310Q0989 N73HMTrn Aviation LLC · Lewes, DES/N 421C0234 N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033 N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014 N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043 N747CAAction Air Express Inc · Santa Monica, CAS/N 421C0850 N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905 N748MGEl Paso Aero Inc · El Paso, TXBuilt 1974 · S/N T310Q1128 N749CABig Bear Resorts Inc · Big Bear Lake, CAS/N 421C1239 N7508QZulu Hours LLC · Moneta, VABuilt 1969 · S/N 310Q0008 N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530 N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030 N7549QAlford Air Transportation LLC · Kernersville, NCBuilt 1972 · S/N 421B0341 N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604 N7557QCircle C Aviation LLC · Orlando, FLBuilt 1972 · S/N 421B0345 N755ACAirswiss Inc · Wilmington, DEBuilt 1968 · S/N 402A0001 N755BCMav Management LLC · Rockledge, FLBuilt 1978 · S/N 421C0497 N757CAKenyon Walter C · Eureka Springs, ARBuilt 1972 · S/N 310Q-0535 N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049 N7584QArnold Brandon M · Roswell, NMBuilt 1970 · S/N 310Q0084 N75CBEastmann Transport Services LLC · El Paso, TXBuilt 1975 · S/N 421B0861 N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912 N75SKRick Broke Entertainment LLC · Conyers, GABuilt 1974 · S/N 421B0646 N7624QFhs Aero Co · Olathe, KSBuilt 1973 · S/N 421B0363 N762CACullum Transportation LLC · North Charleston, SCBuilt 1981 · S/N 421C1214 N762TBAero Crafter LLC · Miami, FLBuilt 1977 · S/N 421C0213 N763JCPilot Services Of Ohio LLC · Loveland, OHBuilt 1976 · S/N 421C0211 N767RRRed Leasing LLC · Juneau, AKBuilt 1972 · S/N 310Q0455 N767ZRubin Broadcasting Inc · Dallas, ORS/N 421C0401 N76MDNovey Gabriel Antonio · Panama CityNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N 402B1055 N76MJJzw Aviation LLC · North Salt Lake, UTBuilt 1981 · S/N 421C1204 N7702QRobinson Meyer · Daphne, ALBuilt 1970 · S/N 310Q0202 N7704QNyerges James R · Pflugerville, TXS/N T310Q0204 N770CSFlying Cpa LLC · Colorado Springs, COBuilt 1975 · S/N 421B0877

Back to AD 75-23-08 R5