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.
N4888CGoflight Inc · Birmingham, MIN4895YKeating George W · Fayetteville, ARN4896KBraxtal LLC · Kingfisher, OKN4898CPalo Aerocraft Inc · Salem, VAN4905CAnacapa Capital LLC · Fresno, CAN4909YFremont Airways LLC · Riverton, WYN491ACEw Pegasus LLC · Walnut Creek, CAN4922YHowey Aviation LLC · Woodhaven, MIN4925KAlberts Nelson · Weatherford, TXN4939YDavidson Dan F · Ozona, TXN4940KGoves Abram M · Parker, CON4946KOrion Technology Group LLC · San Diego, CAN4951YH & B Aeronautics LLC · Miamisburg, OHN4959CDoll House Properties Inc · Chesapeake, VAN4960KShuck Drilling Co · Edgar, NEN4965ADks Air LLC · Owasso, OKN4967KBrown Lawson M II DBA · San Diego, CAN4972KEastern Stearman Inc Trustee · Leesburg, VAN4978YBohannon Donald S · Moreland, GAN4981CWatson Michael · Dalhart, TXN4981KCuriel Gabriel · Oakley, CAN4988Marin Miguel A · QuebecN4994KMenefee Jerry V · Carson City, NVN49AJLvml Real Estate Investments LLC · Rio Grande City, TXN49STHedeen Arnold R · Seattle, WAN4ARN4ar LLC · Marienthal, KSN4UDMorse Donald W · Priest Lake, IDN4YYWilliams Scott Griffin · Salt Lake City, UTN504JWPalmer Gary H · San Juan, TXN507HHGrossetete Nugget S · Edgewood, NMN5083WJtc Investments LLC · Tyrone, GAN5086ANeeley James L · Temecula, CAN5089C5089c LLC · Fairhope, ALN508TCFisher Travis L · Odessa, TXN50DDQualitair LLC Trustee · MichelstadtN50RHPlane Fun Inc Tr Trustee · Snellville, GAN50SHVitatoe Industries Inc · Chillicothe, OHN5105YMcduff Douglas M · Cook, MNN5106CQuest Aviation Inc · Lake City, FLN5107CDalrymple Michael J · San Luis Obispo, CAN5107WRugger Investment Group LLC · Sheridan, WYN510WFFuel Center Plus Inc · Silver City, NMN5119YWby Aviation LLC · Lewes, DEN5124WBest Life Aviation LLC · Cedar Park, TXN512SBN512sb LLC · Austin, TXN512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEN5130AAll Florida Aviation Inc · West Palm Beach, FLN5130YMerritt LLC · Leesburg, VAN5134WPlane Fun Inc Tr Trustee · Snellville, GAN5144UAeronaut LLC · Saint George, UT
Back to AD 98-05-14 R1