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.
N62890Fixed Wing Holding Co Inc · Pembroke Pines, FLN62891Wings Over Texas Holdings LLC · Denton, TXN6289ABright James D · Clyde, NCN6289DYecny Enterprises Inc · San Luis Obispo, CAN6289FSbk Aviation LLC · Festus, MON6289JS K Bound LLC · Missoula, MTN6289LSnyder Gary M · Chino, CAN6289URegistered aircraftN6289WCronk Howard · Council Bluffs, IAN628APThomas Lucas G · Beebe, ARN628ATPayne David P · Lamar, CON628AWHobart Aviation Inc · Akron, OHN628FTFlorida Institute Of Technology · Melbourne, FLN628GRKrause Jason M · Glendale, AZN628GTWimberly David T · Nokomis, FLN628JCDelaney Patrick James · Marion, TXN628MKFarmer Peter E · Heber Springs, ARFirst renewal noticeN628PVL00 Fliers LLC · Lewes, DEN628RAHencken H Gray · Winter Park, FLN628RBBrown Michael C · Erie, KSN628RGKozubek Richard R · Shady Shores, TXN628SCMartin Jesse W · Scottsdale, AZN628TCLayton James L · Carrollton, GAN628ZGlantz Richard L · Whitefish, MTN62901Bates Field Aero Club Inc · Mobile, ALN6290APfeifer Carol A · Victoria, KSN6290JMclaen Family LLC · Queen Creek, AZN6290LMooney Chance · Collins, MSN6290UCarney James A · Dallas, TXFirst renewal noticeN6290VDelta Sierra Aviation LLC · White Salmon, WAN62918Neron II LLC · New Smyrna Beach, FLN6291LDancy Isaiah A · Richwood, WVN6291TEmerald City Aircraft & Leasing Inc · Port Orchard, WAN6291WBrenton Perry · Crestview, FLN6291ZBordelon Thomas D · Elephant Butte, NMN6292RHynes Kevin P · Wichita Falls, TXN6292UCherry Creek School District No 5 · Greenwood Village, CON6292WAmerican Aviator LLC · Arlington, TXN62938Two Guys Aviation LLC · Idaho Falls, IDN6293GMindy Limited LLC · Muscatine, IAN6293HSpace Coast Aircraft Co · Merritt Island, FLN6293JClear Horizon Holdings LLC · Cheyenne, WYN6293UCairn Holdings LLC · Highlands Ranch, CON6293WFisher Russell D · Vacaville, CAN62946Christiansen Aviation LLC · Wilmington, DEN6294BAusten Tim · Oregon City, ORN6294CB A R C Asset Management LLC · Boynton Beach, FLN6294LSmith Samantha K · Middleburg, FLN6294MN6294m LLC · Boynton Beach, FLN6294RMitrenko Alexander V · Selinsgrove, PA
Back to AD 90-04-06 R1