Registered aircraft · 1,110

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:96-18-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13') 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:96-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
  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:96-18-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-18-13')
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.

N38PSAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 206 N391BVcs Encore LLC · Austin, TXBuilt 1996 · S/N 258321 N393SCN169px LLC · Delaware, OHBuilt 1989 · S/N 650 N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228 N39FNGh Equipment LLC · Dover, DEBuilt 1974 · S/N 006 N39GXPitch N Power Aviation Inc · Jupiter, FLBuilt 1982 · S/N 232205 N400CZDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 547 N400GPIcmc Idaho LLC · Salinas, CAS/N 423 N400GSGreen Savoree Transportation LLC · Carmel, INBuilt 2001 · S/N 134 N401JWWatts John I · Murchison, TXBuilt 1975 · S/N 46 N404BYMalagamar LLC · Fort Myers, FLBuilt 1988 · S/N 650-0152 N404FZBogey Bird II Inc · Jeffersonville, INBuilt 1985 · S/N 473 N406CUSs Leasing II LLC · Eau Claire, WIBuilt 1992 · S/N 650-7010 N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578 N40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 2041 N40GPBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 45-2061 N411SCRegistered aircraftBuilt 2004 · S/N 258653 N412DAVida Trade And Management Group LLC · Charlotte, NCS/N 258061 N412SWThunderforce Investments LLC · Washington, DCBuilt 2002 · S/N 238 N413HSAerotrust Services Corp Trustee · Wilmington, DES/N NA0413 N413MHFastair Inc · Columbia Station, OHBuilt 1987 · S/N 650-0148 N414PEAerotrust Services Corp Trustee · Wilmington, DES/N 258090 N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657 N419MKAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1993 · S/N 066 N422CSBusiness Jet Managers Inc · Canton, MIBuilt 1988 · S/N 258110 N423SGSworks Aviation LLC · Chicago, ILS/N 258472 N424JRGravitas Aviation LLC · Dallas, TXBuilt 1984 · S/N 405 N424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 169 N427RRTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 6500178 N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154 N429FCLopez Fabio · Denver, NCBuilt 1983 · S/N 091 N42GEWatts John · Murchison, TXBuilt 1974 · S/N 20 N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509 N431CKKalitta Charters LLC · Ypsilanti, MIBuilt 1981 · S/N 431 N432SMWorldwide Option LLC · Lewes, DEBuilt 1996 · S/N 258293 N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641 N437SJBank Of Utah Trustee · Salt Lake City, UTBuilt 1986 · S/N 437 N43MFMed Flight Air Ambulance Inc · Albuquerque, NMBuilt 1980 · S/N 284 N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628 N440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 85 N440RDDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 25270 N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524 N442MSWd Aviation Group Inc · Atlanta, GAS/N NA0460 N444CWTexas Aero Jet Sales 1 LLC · Wilmington, DEBuilt 1984 · S/N 650-0064 N444HCPdii LLC · Concord, NCBuilt 1992 · S/N 064 N444PERaptor Aviation Inc · Port Saint Lucie, FLBuilt 1984 · S/N 143 N445NAirblue Eagle Inc · Houston, TXBuilt 2002 · S/N 202 N448GRVenti Air Service Inc · Coral Gables, FLBuilt 1993 · S/N 070 N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573 N44MQAircraft Holdings Solutions LLC Trustee · Newark, DEBuilt 1994 · S/N 6507043

Back to AD 96-18-13