Registered aircraft · 785

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.

N555VEPia Avcenter LLC · Peoria, ILBuilt 1979 · S/N 11546 N558TJMorgans Flying Service LLC · Morse, LAS/N 458B N559CGOrtiz Luis Emerito Nieves · Ciudad De PanamaNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 11530 N55CEUnited States Army Corps Of Engineers · Omaha, NEBuilt 2000 · S/N DC-903B N5611XMarshall Jerry D · Hachita, NMBuilt 1978 · S/N 2429R N561UPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N AT-561 N563TRKolob Canyons Air Services Inc · Wilmington, DES/N AT563 N564TRCareer Aviation Co · Wilmington, DES/N AT564 N573GUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N AT-446B N57RSKolob Canyons Air Services Inc · Wilmington, DES/N 11149 N57VEN64fd LLC · Wilmington, DES/N 42-5527027 N580ERBlue Ocean Aerospace LLC · Fort Collins, COBuilt 1981 · S/N 11669 N580SBott Radio Network Inc · Gravois Mills, MOBuilt 1979 · S/N BE-77 N586DVFlying A Flight Service LLC · Safford, AZBuilt 1979 · S/N 11553 N5878KClearwater Airco LLC · Anchorage, AKBuilt 1980 · S/N 11626 N58LASpeedstar Express LLC · Las Vegas, NVBuilt 1982 · S/N SH1979 N5926KGulfstream Aerospace Corp · Savannah, GABuilt 1981 · S/N 11674 N599ASTtc Aircraft Leasing Inc · Celina, TXBuilt 1980 · S/N 441-0183 N59KSOconnell Meares Investments Ltd · Tampa, FLBuilt 1974 · S/N 664 N59RTBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 4410111 N5LCCalm Air Aviation Inc · Nunica, MIS/N 433 S.A.N5LNM7 Aviation Services LLC · Houston, TXBuilt 1995 · S/N DC878B N600JEDeja Mu LLC · Rye, NYS/N 403SA N600PSPlane Services LLC · Twin Falls, IDS/N 11537 N601SDNorthern Jet Sales LLC · Port Saint Lucie, FLBuilt 1973 · S/N 610 N604ARConstruction Helicopters LLC · Howell, MIBuilt 1981 · S/N 289 N604ECEast Coast Flight Services Inc · Easton, MDBuilt 1985 · S/N 646 N6096YKlein Flying Service Inc · Lawrenceville, ILBuilt 1993 · S/N G5-101 N60BMValiair Lc Trustee · Casper, WYS/N 11172 N60TEAerostar Holdings LLC · Kalispell, MTS/N 1515SA N6105LWorld Class Aviation Inc · Peachtree City, GAS/N DC-831M N611BABemidji Aviation Services Inc · Bemidji, MNBuilt 1985 · S/N AC611B N611RHMcneely Charter Service Inc · West Memphis, ARBuilt 1981 · S/N AT423 N61230Ag Solutions LLC · Garden City, KSBuilt 1994 · S/N G5-104 N6127LAg Solutions LLC · Satanta, KSBuilt 1994 · S/N G5-103 N6136ZAg Solutions LLC · Satanta, KSBuilt 1996 · S/N G6-138 N61374Hinkle Airspray Inc · Cavalier, NDBuilt 1994 · S/N G6-119 N613ALChamberlin Aviation LLC · Wilmington, DEBuilt 1987 · S/N T2 N613MAMarsh Aviation Co · Mesa, AZBuilt 1954 · S/N 522 N615DPRay Aircraft Leasing LLC · Tuscaloosa, ALBuilt 1976 · S/N 11317 N616KLFraser Peter · Powell Butte, ORBuilt 1973 · S/N 267 N616PSDena'Ina Leasing Agency LLC · Anchorage, AKBuilt 1979 · S/N T316 N618SCArguelles Jamie D · El Paso, TXBuilt 1983 · S/N 618 N619BABemidji Aviation Services Inc · Bemidji, MNBuilt 1985 · S/N AC619B N61JBSierra Foothill Properties LLC · Reno, NVBuilt 1979 · S/N 417 S.A.N6207GBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N G10-178 N620ARTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 379 N62375Scott Flying Service Inc · Bono, ARBuilt 1988 · S/N 806B N626KBMoses International Inc · Bellevue, MIBuilt 1980 · S/N 441-0143 N62CNWiljan Holdings LLC · Lake Wales, FLBuilt 1980 · S/N 436 S.A.

Back to AD 2011-18-51 R1