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.
N8323AWisconsin Aviation Inc · Watertown, WIN8323BMidcoast Helicopter Services Inc · La Ward, TXN8323VToczek Keith E · Yankton, SDN8323WConcord Aviation Services LLC · Concord, NHN8324Veal Tim S · Egegik, AKN8324EGc Aviation Services-1 LLC · Miamisburg, OHN8324USyren David N · Anchorage, AKN8324WSwofford Sherman A · Inman, SCN8324YStein Anthony J · Locust Grove, GAN8325EAnzaldi Carl J · Cherry Valley, CAN8325LLeading Edge Flight Services Inc · Hampshire, ILN8325RSy Aviation LLC · Judsonia, ARN8325TColumbia Jet Center Inc · Columbia, MON8325UCross Dustin · Tonto Basin, AZN8325VPct Hawk Inc · Wilmington, DEN8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKN83268Wright Kim B · Bozeman, MTN8326CNewman Carl D · Phoenix, AZN8326ENorton Eric D · Nauvoo, ILN8326WBarnwell Sam M · Traverse City, MIN8326YEastern Stearman Inc Trustee · Leesburg, VAN83271Nohrenberg Raymond C · Pingree, NDN83272Bowker James D · Willow, AKN83275Perry Scott D · Hood River, ORN83278Hamlin Andrew J · Two Rivers, AKN8327RWelsh Rick F · Ewing, VAN8327WFuture Flying LLC · Manassas, VAN8327YKaeser Robert E · Lafayette, INN83281Chandler Air Service Inc · Chandler, AZN83283Hayton James B · Sedro Woolley, WAN83285Dyches Abigail · Eagle River, AKN8328CSky Craft LLC · Powell, OHN8328PSale Reported · Lewes, DESale reportedN8328TOcala Aviation Services Inc · Ocala, FLN8328UHale Larry D · Charlotte, NCN8328WTolmachev Nikolay A · Anchorage, AKN8328YSims Chris · Colleyville, TXN8329649 Ranch Co LLC · Odonnell, TXN83299Brewer Danny E Jr · Nikiski, AKN8329VBuck Timothy A · Howland, MEN8329YHarbock Inc · Wilmington, DEN832ABeck John Edward · Newton, IAN832ATDot Aviation LLC · Wilmington, DEN832DCCase Daniel J · Spokane, WAN832RMMcbride Christen L · Elgin, TXN832TFAir Fleet Holdings LLC · Missoula, MTN832WWJacobson Richard T · Overton, NVN8330LParis Air Inc · Vero Beach, FLN8330RBriggs Michael L · Howell, MIN8330VJensen Carla J · Pingree, ID
Back to AD 90-04-06 R1