Registered aircraft · 1,770

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:2018-03-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:2018-03-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:2018-03-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:2018-03-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:2018-03-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:2018-03-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.

N712JDCpch Aviation LLC · Jacksonville, FLS/N 421C0908 N712JWFalcon & Phoenix Aviation LLC · Las Vegas, NVBuilt 1969 · S/N 421A0128 N7135GRegistered aircraftBuilt 1977 · S/N 421C0284 N71544Miller Family Enterprises LLC · Humble, TXS/N 421B0552 N716RMMattracks Promotions Inc · Karlstad, MNBuilt 1974 · S/N 421B-0528 N717BDWeathered Aviation Inc · Rogers, ARBuilt 1979 · S/N 414A0337 N717CGContinental Title Trust LLC Trustee · Wichita, KSBuilt 1974 · S/N 414-0495 N717LRJnnss LLC · Hillsborough, NJS/N 421C1109 N71HEBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 425-0085 N71JRSouthgate Development Inc · Wichita Falls, TXBuilt 1976 · S/N 421C0066 N71MEB200 Holdings LLC · Gilbert, AZBuilt 1969 · S/N 401B0007 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 N72JAOtter Air LLC · Fishers, INBuilt 1979 · S/N 414A0333 N72KGM & P Aviation LLC · Byhalia, MSBuilt 1980 · S/N 414A0513 N730AFB Fam LLC · Texico, NMBuilt 1976 · S/N 414-0853 N7316UDarvek LLC · Las Vegas, NVBuilt 1965 · S/N 411-0016 N73DWQueen Bee Air Specialties Inc · Rigby, IDBuilt 1981 · S/N 425-0089 N73HMTrn Aviation LLC · Lewes, DES/N 421C0234 N73TBMagic Leasing LLC · Peotone, ILBuilt 1981 · S/N 414A0474 N740AGStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 421A-0033 N740CAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0277 N741DFSeeding Operations And Atmospheric Res (Soar) LLC · San Angelo, TXBuilt 1975 · S/N 414-0633 N744BWDobson'S Leasing Co LLC · Ocoee, FLBuilt 1981 · S/N 414A0658 N744CAMay Richard Ullmann · Soquel, CAS/N 421C1014 N745CARegistration Pending · Dover, DERegistration pendingS/N 421C1043 N745EPSumner Michael · Hahira, GABuilt 1974 · S/N 414-0498 N747CAAction Air Express Inc · Santa Monica, CAS/N 421C0850 N747WSHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0080 N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905 N749CABig Bear Resorts Inc · Big Bear Lake, CAS/N 421C1239 N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828 N74RFAir Flair Inc · Maurice, IABuilt 1983 · S/N 425-0153 N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217 N7549QAlford Air Transportation LLC · Kernersville, NCBuilt 1972 · S/N 421B0341 N754JSDy34 LLC · Adamsville, TNBuilt 1975 · S/N 414-0643 N754KCPlane Crazy Aviation LLC · Fargo, NDBuilt 1981 · S/N 414A0803 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 N757RHPanther Partnership Equipment I LLC · Gibsonton, FLS/N 421C1049 N759JSIsland 414 LLC · St Simons Island, GAS/N 414-0936 N75CBEastmann Transport Services LLC · El Paso, TXBuilt 1975 · S/N 421B0861 N75GBPro Aire Cargo & Consulting Inc · Oshkosh, WIBuilt 1975 · S/N 402B0912

Back to AD 2018-03-03 R1