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.
N234SBDaly Arthur P · El Paso, TXN235WJmzb Leasing LLC · Amarillo, TXN236PTmg Investment Properties LLC · Surprise, AZN23KBRegistered aircraftN242RYCity Management Corp · Sunriver, ORN2437UPlanetosea LLC · Doylestown, PAN246JJlr Resources LLC · Naples, FLN24NHBeyer Roger · Paw Paw, MIN24TBDalks Leasing Inc · Wilmington, DEN252SWSymns Robert A · Aguila, AZN25JGCenturion Aircraft Limited · Centennial, CON25WDSale Reported · Greeley, COSale reported, canceledN267LMAviation Trust Co LLC Trustee · Oklahoma City, OKN26KNSky King Aviation Inc · Weslaco, TXN26RSStacey Enterprises Inc · Ogden, UTN274HAPacific Rain Inc · Arroyo Grande, CAN278PBP21000318 Inc Trustee · Wilmington, DEN27SC5c Aviation LLC · Scottsdale, AZN281UDStanley David Wayne · Burleson, TXN283RDBengtson Douglas Richard · Woodinville, WAN28JMWestern Aviation Services LLC · Cheyenne, WYN2RXJbs Enterprises LLC · Hamilton, MTN300HCPs Air LLC · Evansville, INN308BCMike Kilo Foxtrot LLC · Wilmington, DEN30HDRegistered aircraftN30VGGeoterra Inc · Eugene, ORN311JBJack Brain And Associates Inc · Castro Valley, CAN312SCBarker Family Investments Management Co LLC · Tyler, TXN313MPAlpha Bravo Charlie 1 Corp · Houston, TXN313WTCinotto Robert L · Rhome, TXN3153BSeverson James A Jr · Tualatin, ORN316RWFour States Tire & Service Inc · Cortez, CON31MDKarmy Paul Edward · Burleson, TXN3210PKilcullen Brian DBA · Fort Lauderdale, FLN321BLWalls Bruce · Middletown, OHN321BPCenturion Air Inc · Ridgewood, NJN32331Sowers Richard M · Reno, NVN323DASky West Aviation Inc Trustee · Albuquerque, NMN323DCFlymax Aircraft LLC · Ball Ground, GAN325RPN325rp Corp · Willow Spring, NCN331CBN331cb LLC · Great Falls, MTN339DGRegistered aircraftN344AJQualitair LLC Trustee · MichelstadtN34KFRsb Properties LLC · Lewes, DEN34VFRomag Air Services Inc · Mc Lean, VAN350GZValiair Lc Trustee · Casper, WYN350LCDaly Arthur P · El Paso, TXN355YPlussa Mark George · Clermont, FLN3605PSmith Bryan · Wenatchee, WAN369HCCornerstone Mapping Inc · Roca, NE
Back to AD 98-05-14 R1