AD 96-03-13
Registered aircraft · 1,042
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-03-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-03-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-03-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-03-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.
N918MTIntegrity Aircraft Title Holdings LLC · Portland, ORN919REIvy Brothers Aviation LLC · Kilgore, TXN91MFCkw Aviation LLC · Dalhart, TXN91RKAir Flight Inc · Fort Lauderdale, FLN921AZArizona Department Of Public Safety · Phoenix, AZN921MFPuerto Coral Corp · Wilmington, DEN922ALBallard Aviation Inc · Newton, KSN923ASDjp Properties LLC · Selma, CAN924ACDena'Ina Air Taxi LLC · Anchorage, AKN924JBN924jb LLC · Little Rock, ARN926TJBlackhawk Consulting LLC · Raceland, LAN928KAction Offshore LLC · Port Arthur, TXN928KLKa-B200 LLC · San Angelo, TXN929BWSkyway K LLC · Middletown, DEN92JTHigh Shadow LLC · Roach, MON92WCAviation Group LLC · Wilmington, DEN933RTZito Aviation LLC · La Salle, CON935AJDouble C Air LLC · Sacramento, CAN93AMAsm Aviation LLC · Bismarck, NDN93GTDodson International Parts Inc · Rantoul, KSN93SFArctic Legacy Aviation LLC · Anchorage, AKN93VDAbsl Construction · Hayward, CAN93WTWes Tex Drilling Company · Abilene, TXN940HCAll Aviation LLC · Hudson, WIN942CEVoice Of Evangelism Outreach Ministries · Cleveland, TNN944CWby Enterprises II LLC · Jackson, TNN944LSJmb Air LLC · Algona, IAN948CEPro-Serve Aviation LLC · Englewood, CON948HBNew Mountain Aviation LLC · Englewood, CON949BWBering Air Inc · Nome, AKN949CFTee Pee Wings LLC · San Angelo, TXN949MAMajestic Aviation LLC · Billings, MTN949REAviation Trust Company LLC Trustee · Oklahoma City, OKN94PGM Wall Inc · Chesapeake, VAFirst renewal noticeN950AAAlpine Aviation Inc · Provo, UTN950MBLos Angeles County Sheriffs Department · Long Beach, CAN953AJS A Comunale Co Inc · Barberton, OHN953RCRmc Aviation LLC · Trumann, ARN954MSBank Of Utah Trustee · Salt Lake City, UTN954ZAZulu Air LLC · Opa Locka, FLN957CBBd Air LLC · Battle Ground, WAN95GADrco Aviation LLC · Matthews, MON95LMT L Irrigation Co · Hastings, NEN95TTKelly Air LLC · Cedar Falls, IAN95UTPacificorp · Portland, ORN95WAAlpine Aviation Inc · Provo, UTN960JPElite Medical Air Transport LLC DBA · El Paso, TXN969MAVenable Group LLC · Tupelo, MSN96AMTexas A&M University System · College Station, TXN96CESummit Air Leasing LLC · Portage, MI
Back to AD 96-03-13