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.
N8521YVan Devere Joseph C · Akron, OHN8522CParylak Sean P · Colchester, CTN8522DAdams Daryl S · Monticello, FLN8522EHall Robert P · Decatur, ALN8522FHhi Farms LLC · Hamilton, MIN8523PTubbs Jeffrey E · Kasilof, AKN8523YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8524DBig Bend Community College Foundation · Moses Lake, WAN8524YGasmire David C · Fredericksburg, TXN8526Core Tech Services & Supply LLC · Odessa, FLN8526FMinton Gabriel D · Wexford, PAN8526KBaratta Richard J · Tower, MNN8526YCarlile John D · The Villages, FLN8526ZRyther John W · Austin, MNN8527CRegistered aircraftN8527YHatbright Farm LLC · Wilmington, DEN8528Somerville Billy J · Newport, NCN8528CJain Abhishek · Weehawken, NJN8528NWright Jeffrey C · Canby, ORN8528YYoung David A · Lakeland, FLN8529RElias Bernard J · Hampton, GAN852ATWings Over Texas Holdings LLC · Denton, TXN852CPPmbarrett Aviation LLC · Tucson, AZN852DAHendrix Rex · Pell City, ALN852HHoffart Paige D · Omaha, NEN852NBurns Dwayne · Madera, CAN852NDPlane Nonsense Inc · Middletown, DEN852PProfessional Training Aircraft LLC · Wilmington, DEN852TStudarus John E · Sacramento, CAN852TXFormhals Steven P · Boerne, TXN8530DCurcio Steve J · Oak Creek, WIN8530YMouat Michael W · Hemet, CAN85348Passeno Mark A · Cheboygan, MIN8534CSalter Christopher D · Elberta, ALN8535YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN8536DAnderson Kel G · Alta, IAN8536XTrask John D · Portsmouth, VAN8536YEastern Flight Services Inc · Ronkonkoma, NYN8537Kopaska Linda · Guthrie Center, IAN8537MRegistered aircraftN8538DMarble Jere D · Dayton, NVN8538JHarrison Gene R · Pendleton, ORN8538YRothstein Steven R · Punta Gorda, FLN8539DEdens Ferlin C · Boone, CON8539YTwinco Leasing LLC · Yacolt, WAN853AAAb Prop Plane I LLC · Metairie, LAN853AKKase Gayle L · Wasilla, AKN853BBSaile Daniel K · Skiatook, OKN853CEWilford Boone · Cotter, ARN853LCCox Leon F · Ruffin, NC
Back to AD 90-04-06 R1