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.
N751JCCbr Aviation LLC · Delaware, OHN752JCTeam Aero LLC · Shawnee, KSN757TRRegistered aircraftN75ABRivers Equipment III LLC · Nashville, TNN75JMJast Air LLC · Wilsonville, ORN75MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN75VCSunshine Aero Industries Inc · Crestview, FLN75XPRedd Air LLC · Vancouver, WAN760RARoyal Air Freight Inc · Waterford, MIN762MG1mg LLC · Fort Wayne, INN766HKDac Acquisition Co LLC · Easton, MDN766RARoyal Air Freight Inc · Waterford, MIN76CDBankair Inc · West Columbia, SCN76CKKalitta Charters LLC · Ypsilanti, MIN770CCTaughannock Aviation Corp · Ithaca, NYN770FGHangar LLC · Las Vegas, NVN777BLBlackstone Mm Assets LLC · Beverly Hills, CAN777CJHarvest International Ministries Inc · Texarkana, ARN777FCAlghazzawi Hani · Holland, OHN777MXAirplane III LLC · Fulshear, TXN777QLMed Air LLC · Lawrenceville, GAN777XYCair Leasing LLC · Wilmington, DEN77HFCb Aircraft Inc · Fort Lauderdale, FLN77LXWatford Horizons LLC · College Station, TXN77METrilogy Investments Ag LLC · Las Vegas, NVN77SFSeneca Foods Corp · Penn Yan, NYN780DWBemo23 Assembly LLC · New York, NYN783FSFarspo LLC · Oklahoma City, OKN784AMBank Of Utah Trustee · Salt Lake City, UTN787CVRowley Aviation Inc · Fort Lauderdale, FLN789HAClark County Jets LLC · Sellersburg, INN789SRBank Of Utah Trustee · Salt Lake City, UTN790JRTransenergie Inc · Houston, TXN791CPMaxus Capital Group LLC · Cleveland, OHN793RCLfg Aviation Holdings LLC · Kalispell, MTN795FMCypress Aircraft Sales LLC · Clermont, FLN798PAJli Holdings Group Inc · Johns Island, SCN799MWSabre 42 Inc · Lewes, DEN799RMBank Of Utah Trustee · Salt Lake City, UTN799SN143bl LLC · Hixson, TNN79CJV1vr LLC · Wilmington, DEN79LE206 Holdings LLC · New Orleans, LAN7ABBce Jets LLC · Cuero, TXN7KCFalcon 200 Inc · Nashville, TNN7WFFang Aviation LLC · Wichita Falls, TXN7ZGHhwr Whitetail Ranch LLC · Waco, TXN800ABCheck Clearing House Aviation LLC · Glenwood Springs, CON800AFJec Hawker LLC · Pflugerville, TXN800CJCdmr Pj LLC · Jackson, NJN800DWJfm Air II LLC · Wilton Manors, FL
Back to AD 96-18-13