AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N866MMMorris Engineering Group LLC · Juneau, AKN866PUTrustees Of Purdue University · West Lafayette, INN866RHMerrill D J · Topsham, MEN866RPShelton Greg N · Collinsville, OKN866TSSteier Tim A · Blue Earth, MNN866WKMeyer Benjamin R · Glenburn, MEN866ZPlane Crazy Aviation LLC · Hickory, NCN8670CReabe Damon P · Ripon, WIN8670EMarvin Carlton R · Tomahawk, WIN8670YTerpin Gregory A · Champion, PAN86711Crane David D · Cadott, WIN86713Tuckerman Flying Service Inc · Tuckerman, ARN86714Odonnell Daniel V · Dover, DEN86715Yellerhammer LLC · Warner Robins, GAN86726Sale Reported · Mesa, AZSale reportedN86727Murray Eric J · Kamas, UTN8672DPlate Ronald L · Soldotna, AKN8672EMock Joseph R · Huntsville, TXN8672VHarris Kenneth L · Greeley, CON86738Myran Kenneth · Taylor, NDN86742Parker James T · Palmer, AKN8674VIberlin Ranch · Gillette, WYN86752J&M Aviation Supply Inc · Shreveport, LAN8675EBarbarich Allen G · Las Vegas, NVN8675RMeyer Jason P · Tempe, AZN8675YKatz Daniel J · Sausalito, CAN86768Tarver Dalton K · Fallon, NVN8676CGillett Glen C · Roy, MTN86771Seratt Timothy G · Harviell, MON8677CSchneider Richard J · Wasilla, AKN8677VAlbij3 LLC · Milton, FLN8678YHealey Patrick T · Tucson, AZN86796Perkins Brad · Thomas, OKN867AAWings Over Texas Holdings LLC · Denton, TXN867BDSackett Heather S · Krum, TXN867CLPavilonis Charles A · Jonesboro, GAN867CTTessos Air Service Inc · Wilmington, DEN867LAHillsboro Aero Academy LLC · Hillsboro, ORN867PProfessional Training Aircraft LLC · Wilmington, DEN867PUTrustees Of Purdue University · West Lafayette, INN86806Officer Jarod P · Petaluma, CAN86807Wells Jeffrey V · Mackay, IDN8680EGibson Kevin S · Porterville, CAN86813Holton Allen M Jr · Torrance, CAN8681CEvans Richard H · Niceville, FLN8681DWayward Willow LLC · Wasilla, AKN86820Piercy Ron · Moses Lake, WAN86822Hofer Gary D · Huron, SDN86828Robinson William D · Greer, SCN8682DCasabonne Family Ltd Partnership · Hope, NM
Back to AD 90-04-06 R1