Registered aircraft · 786

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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SA N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N10192Frontier Agricultural Service Inc · Calexico, CABuilt 1989 · S/N 401-0731 N101MCMarc Inc · Bolton, MSBuilt 1973 · S/N T234 N101WAP M Leasing Inc · Perris, CABuilt 1969 · S/N SH1859 N103SLAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1985 · S/N 11735 N1050HBush Monster LLC · Caldwell, IDBuilt 2024 · S/N 001 N105RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0353 N106ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0917 N107BHBighorn Airways Inc · Sheridan, WYBuilt 1979 · S/N 165 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N109BHBighorn Airways Inc · Sheridan, WYBuilt 1981 · S/N 192 N112BHBighorn Airways Inc · Sheridan, WYS/N 292 N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233 N114HKGeneral Atomics Aeronautical Systems Inc · Poway, CABuilt 2008 · S/N FC114 N114LHAirborne Support Group LLC · Marion, MTBuilt 1974 · S/N SH-1926 N1158Alaskan Air Charter LLC · Anchorage, AKS/N SH1951 N1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N116TLTordrillo Mountain Aviation LLC · New York, NYBuilt 1956 · S/N 174 N117BHBighorn Airways Inc · Sheridan, WYBuilt 1980 · S/N 171 N117CCEv Advisors LLC · Scottsdale, AZBuilt 1979 · S/N T-325 N11MMN11mm LLC · Anchorage, AKBuilt 1979 · S/N 441-0105 N11SJSouthland Metroplex Aviation LLC · Colleyville, TXBuilt 1973 · S/N 285 N120TMInterstate Automotive Services Inc · Franklin, TNBuilt 1981 · S/N T-405 N1212CDodson International Parts Inc · Rantoul, KSBuilt 1985 · S/N 441-0346 N121JWGlobal Jet LLC · Missoula, MTBuilt 1975 · S/N 11299 N122CKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 374SA N122MAPanda Aviation Inc · Washougal, WAS/N 207 N124PAJ31 Partners LLC · Nashville, TNBuilt 1984 · S/N 643 N124PCSaxton Leasing Inc · Plymouth, MIS/N 438SA N125MMFox Tango Tango Inc · Houston, TXBuilt 1979 · S/N 11605 N127HJPonderosa Aviation LLC · Safford, AZBuilt 1978 · S/N 11467 N128EZN128ez LLC · Anchorage, AKBuilt 1979 · S/N 441-0128 N12MFMontana Aircraft Trust Inc Trustee · Bozeman, MTS/N T-417 N12VAAirborne Research LLC · Fort Pierce, FLS/N 96062 N1331CRyan Air Inc · Anchorage, AKBuilt 1982 · S/N 265 N13NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 441-0090 N13RABarney Adam Joseph · Altamonte Springs, FLBuilt 1975 · S/N 11235 N13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694 N1420VCommander Trust LLC · Fort Lauderdale, FLBuilt 1979 · S/N 11524 N142JBAlaska Remote Outfitters LLC · Kenai, AKBuilt 1956 · S/N 74 N143JACosco & Associates Inc · Crestview, FLBuilt 1974 · S/N 324 N144PLCatskill Transportation LLC · Kingston, NYBuilt 1984 · S/N 42-5527014 N145FSSolitaire LLC · Appleton, WIS/N 437 S.A N145WFAircraft Propulsion Leasing LLC · Holland, OHBuilt 1993 · S/N DC-824B N14FJLand Safely LLC · Tinton Falls, NJBuilt 1980 · S/N 441-0118 N14NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1980 · S/N 4410171 N14TA35th Terrace LLC · Wellington, FLBuilt 1980 · S/N 441-0168 N150BAKenai River Xpress LLC · Soldotna, AKBuilt 1953 · S/N 15

Back to AD 2011-18-51 R1