AD 98-05-14 R1
Registered aircraft · 909
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:98-05-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-05-14-R1')
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:98-05-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-05-14-R1') 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.
N731RWAdvanced Products Sales LLC · Tempe, AZN731SCMoore Scott A · Longview, TXN731TPHangar 28 LLC · Littleton, CON731XXGrimm John H II · Driftwood, TXN731ZBVanderwaal Shane J · Junction City, WIN731ZFTuggle James L Jr · Scottsdale, AZN7329NRegent Trust Corp Trustee · Wichita, KSN732ETCaudill Jimmy L · Grove, OKN732RFWolvington Howard W · Genoa, NVN732RSAircraft Guaranty Corp Trustee · Oklahoma City, OKN732XHGwin Brandy L · El Lago, TXN732ZHDe La Porte Herb · Elyria, OHN7334PUp And Away Aviation LLC · Poughkeepsie, NYN7335NEnrique Elias Luis · Chandler, AZN7336CDelta Kilo Av8 LLC · Bonita Springs, FLN7346PIntegrated Avionics Services Inc · Hampstead, MDN734HW206 LLC · Portland, ORN734VSVitatoe Industries Inc · Chillicothe, OHN734WGStone Aviation LLC · Traverse City, MIN734WHObermeyer Keith · Excelsior, MNN7357CPerson Donna Mae · Columbus, NEN7384CFesco Holdings Inc · Alice, TXN7389NKns Properties · Perry, IAN7391PShph LLC · Edwards, ILN739MCaurus Power Inc · Santa Rosa, CAN746ZXSlater R Winston Trustee · St Charles, ILN74ESValiair Ltd Co Trustee · Casper, WYN7559KSkyway II LLC · Naples, FLN7567KCutler Jeffrey R · Columbus, INN7591NJones Michael D · Southern Pines, NCN7599NAir Conejos Inc · El Paso, TXN75DAHenderson John L · Ozona, TXN75LGMarr Lance · Portland, ORN75RCJoffe Zalman · Bahama, NCN75VRSlt Global Alliances LLC · Las Vegas, NVN75WFSjs Holdings LLC · Los Angeles, CAN761BEAnderson Kristian L · Albuquerque, NMN761CWOne Charlie Whiskey LLC · Austin, TXN767RFAircraft Guaranty Corp Trustee · Oklahoma City, OKN7685NFranklin Construction Inc · Chico, CAN7711GTrans Meridian LLC · Fort Myers Beach, FLFirst renewal noticeN7736KValiair Lc Trustee · Casper, WYN777BMJet Air Of South Florida Inc · Deerfield Beach, FLN777DLShamrock Kelly Energy Inc · Blanco, TXN777FYQualitair LLC Trustee · ChelstadtN77BVRegistered aircraftN77GSSouth Carolina Flyers LLC · Aiken, SCN77KRMarsh Aviation LLC · Old Lyme, CTN77RASky West Aviation Inc Trustee · Albuquerque, NMN781DBCooper Roy · Lamesa, TX
Back to AD 98-05-14 R1