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.
N711FJBirner Aviation LLC · Earth City, MON711GFIpo II LLC · Wheeling, ILN711KEN711ke LLC · Wilmington, DEN711LTBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLN713STSilverstar Partners LLC · Houston, TXN715JCFlying Farmer LLC · Wilmington, DEN715LALongbow Aviation LLC · Fernandina Beach, FLN715MGRichard L Richards Pa Trustee · Coral Gables, FLN716BHM Hixson Aviation LLC · Lake Dallas, TXN716DBCervenka Debra A · Santa Rosa Beach, FLN717AMLopez Fabio · Denver, NCN717EBAmigos Al Dia Pr LLC · Carolina, PRN717KVN717kv LLC · Wilmington, DEN717LAAdcnt Management Co LLC · Dallas, TXN717LFOnpoint Avionics LLC · Downey, CAFirst renewal noticeN718HCAcme Leasing II LLC · Nashville, TNN719CACentral Airlines Inc · Leawood, KSN719HGFlightworks Inc · Kennesaw, GAN719SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN71AHAircraft Holding Solutions LLC Trustee · Newark, DEN71ALBastille Energy Corp · Oklahoma City, OKN723CCAgave International LLC · Wellington, FLN724FSSmith Frank Ford Jr · Wilmington, DEN724LTRegistered aircraftN724SAAccess Aviation LLC · Vienna, VAN724TSHilliard Ira V · Spring, TXN725CJClub Jet Investments LLC · Wilmington, DEN725RHEstancia Aviation III LLC · Reno, NVN727TXCitation N79kf LLC · Naples, FLN728LWBleeker Holdings Corp · Stratford, CTN729HBBravo Alpha Aerospace LLC · Camden, DEN729WLBearcat Air LLC · Solon, OHN72AYCababie Sara · Laredo, TXN72FCAlliance Aviation Group LLC · Wilmington, DEN730DFDunn Diehl Farms LLC · Wimauma, FLN731RARoyal Air Freight Inc · Waterford, MIN732AADjcj LLC · Nashville, TNN733GBuzick Air LLC · Bardstown, KYN737MMMadrock LLC · Dallas, TXN73GPTvpx Ars Inc Trustee · North Salt Lake, UTN73LRFalcon N73lr LLC · Belton, TXN740TFTop Gun Air LLC · Pompano Beach, FLN744ARTop Air Texas LLC · Glendale, CAN745MCMiradair LLC · Lake George, NYN745TTFlaghill LLC · Key West, FLN746ARJdm Aircraft LLC · Arlington, TXN747BWOxford LLC · Fort Lauderdale, FLN747CPRoyal Air Charter LLC · El Cajon, CAN7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN750CKMn Aircraft LLC · San Juan, PR
Back to AD 96-18-13