AD 96-18-13
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
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.
N315RCRocklyn National LLC · Syracuse, NYN315SCInternational Skychase Corp · Alachua, FLN316CLCalco 316 LLC · Frisco, TXN316TDBas Part Sales LLC · Greeley, CON3170BSpring Mountain Enterprises Inc · Corvallis, ORN317CQPrivate Fliers LLC · Wheaton, ILN317TTInter Island Yachts Inc · Zephyr Cove, NVN318NWMed Jets USA Inc · Boca Raton, FLN31GJGlobal Jetcare Inc · Brooksville, FLN31KHAery Aviation LLC · Wilmington, DEN31LJDelta November LLC · Lewes, DEN31RARoyal Air Freight Inc · Waterford, MIN31YAInternational Trading Energy Fuels LLC · Houston, TXN31ZVEzair International Leasing And Management Inc · Wilmington, DEN31ZZE D Santos & Associates LLC Trustee · Wilmington, DEN320EJAlliance Aviation Group LLC · Wilmington, DEN320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedN321MSTaughannock Aviation Corp · Ithaca, NYN321VAValiair Limited Co Trustee · Casper, WYN322GC1mg LLC · Fort Wayne, INN322PRN322pr LLC · Scottsdale, AZN323AAE D Santos & Associates LLC Trustee · Wilmington, DEN325EXFalcon 325 LLC · Fort Pierce, FLN325JFN325jf Operating LLC · Dallas, TXN325NWKalitta Charters LLC · Ypsilanti, MIN325RDLow Tide LLC · Riverside, IAN327GALmi LLC · Alpharetta, GAN328JLLamon Aviation LLC · Boise, IDN328PCSn 328 Corp · Fort Lauderdale, FLN329TJForsythe Aviation LLC · Point Lookout, MON32HMAir Mellon LLC · Wilmington, DEN32KBS S K Hawker Group LLC · New Haven, CTN331JVBoulder Falcon LLC · Salt Lake City, UTN331SKD & E Aviation LLC · Missoula, MTN331USN331us LLC · Hillsboro, ORN333DLD&S Aircraft LLC · Chicago, ILN333KEFalconmitch Inc · Sulphur Springs, TXN333PCSemanik Investment Corp · Jacksonville, FLN335KBShelt William J · Denton, TXN335PRGy Aircraft LLC · Daytona Beach, FLN335RCN335 Aviation Corp · Middletown, DEN33612Pmdg Flight Operations LLC · Alexandria, VAN337WRAer Sales Lp · Carrollton, TXN339AVKmwflight LLC · Wilmington, DEN33APGolden Triangle Aviation LLC · Beaumont, TXN33BCSworks Aviation LLC · Chicago, ILN33RCBank Of Utah Trustee · Salt Lake City, UTN33TRAirborne Holdings Inc · Midlothian, TXN343WTPhantom Phlyers LLC · Pearland, TXN345TRJog068 Inc · Lewes, DE
Back to AD 96-18-13