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.
N824CCLg & Gs Holdings II LLC · Middletown, DEN824CKKalitta Charters LLC · Ypsilanti, MIN824MGAti Jet Inc · El Paso, TXN825JWT & C Aviation LLC · Temecula, CAN825LJRoyal Air Freight Inc · Waterford, MIN825QTKjm Air LLC · Aurora, ILN825UWConcept Jet Services Inc · Gainesville, FLN825WKMadunn El LLC · Wayzata, MNN826CALear Management LLC · Tulsa, OKN828MLWalkabout Air Inc · Tampa, FLN82RSFly Mda Aviation LLC · Opa Locka, FLN830DMWord Of Life World Outreach Center Inc DBA · Murrieta, CAN831LXM&N Equipment LLC · Englewood, CON831PC505sj LLC · Jackson, TNN831RWHigher Purpose LLC · Ellisville, MON831VPAlana 650 Aircraft LLC · Waterford, MIN834AFFenair LLC · Toledo, OHN835MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN83FJCj Aviation LLC · Kalispell, MTN83FNGh Equipment LLC · Dover, DEN840BMJsj LLC · Wilmington, DEN840SWN840sw LLC · Vero Beach, FLN841MSSafari Intl LLC · Lewes, DEN841TFRoyal Air Freight Inc · Waterford, MIN845BBN845bb Partners LLC · Richmond, VAN845TXButler Brian S · Oklahoma City, OKN848NAsf Aviation LLC · Cortlandt Manor, NYN84JHFlycarolina LLC · Concord, NCN84TJUsaircraft Inc · Newark, DEN84UPN84up LLC · Wilmington, DEN850BWJetcorp LLC · Fontana, CAN850CCSunshine Aero Industries Inc · Crestview, FLN850ENBcbg Capital LLC · Clearwater, FLN850FJPachy Music Corp · Bellflower, CAN850RARoyal Air Freight Inc · Waterford, MIN850SXN850sx LLC · Lewes, DEN850XMHawker Jet Holdings Xp1 LLC · Opa Locka, FLN851CGBank Of Utah Trustee · Salt Lake City, UTN851LDodson International Parts Inc · Rantoul, KSFirst renewal noticeN855MWMunguia Mario · Downey, CAN855RJJw-N855rj LLC · Mcallen, TXN858SPBrown Lawson M II · San Diego, CAN858WWMontana Aircraft Trust Inc Trustee · Bozeman, MTN85MSAviation Trust Company LLC Trustee · Oklahoma City, OKN85PTWestwind Air LLC · Oklahoma City, OKN85SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN85WTExcalibur International Aviation Inc · Spring, TXN860JAAirborne Aviation LLC · Miami, FLN864BFPsx LLC · Sheridan, WYN865CSReef Aviation LLC · Knoxville, TN
Back to AD 96-18-13