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.
N548TFrasier Samuel R · Gainesville, FLN54905905 Cess LLC · Wilmington, DEN5490BMorcom Aviation Services Inc DBA · Everett, WAN5490HSuperior Flying Services LLC · Superior, WIN5490NHughes David A · Keller, TXN5490WHobbs Alicia · Folsom, CAN54910Somboonsap Patanapong · Oakland Park, FLN5491HSky Hogs LLC · Orange Park, FLN5491KSale Reported · Rowland, NCSale reportedN5491LWinter Sarah A · Hurst, TXN5491PKs Aviation Inc · Atwater, CAN54921Western Antique Aeroplane & Automobile Museum · Hood River, ORN5492HAcme Aircraft Flying Club LLC · Kalispell, MTN5492WSky Park Cherokees Inc · Felton, CAN54933Sammy Supercub LLC Series B · Reno, NVN54938Lentsch Bill · Fairbanks, AKN54939Lang Madison S · Harper, TXN5493RFreedom Flight Center Inc · Hardy, NEN5493ZMcnabb James A Trustee · Grove, OKN54946Goosfraba LLC · Huddleston, VAN54947Christiansen Aviation LLC · Wilmington, DEN5494LZee Sutherland L · Stallings, NCN5494PHillsboro Aero Academy LLC · Hillsboro, ORN5494ZLanham William B · Mineral Wells, TXN54950Allen April Elizabeth · Chardon, OHN54951Skylens LLC · Hammond, LAN54955Space 5 LLC · Fayetteville, GAN54956Fluke Dennis M · Sunset, TXN5495DSorbi Aviation Inc · El Cajon, CAN5495EScotts Helicopter Services Inc · Le Sueur, MNN5495HPeirce Kellie N · Mc Grath, AKN5495KI Fly High LLC · Mesa, AZN5495QNovember Sierra Aviation LLC · Oneill, NEN5495THill Mark D · Magnolia, TXN5495WWings Over Lake Norman LLC · Mooresville, NCN5495ZHayes Robert L · Chesapeake, VAN54960First Eclipse Ltd · Richmond, VAN54968Kangas Kevin L · Fairbanks, AKN5496HWilson Charles L · Seattle, WAN5496LRoda Richard H · Wakefield, RIN5496WMaddux Dawayne E · Weeki Wachee, FLN5496YAmundson Nancy F · Chugiak, AKN54972Snider Scott E · Turner, MTN5497LCardelli Steve V · San Bruno, CAN5497WJethro Charter Flights LLC · Jacksonville, NCN5497ZShira Daniel C · Homedale, IDN54983Jin Jin Aviation LLC · Anchorage, AKN5498HGulf Atlantic Airways Inc · Gainesville, FLN5498WBas Part Sales LLC · Greeley, CON5498ZCunningham Florence Jean · Spokane Valley, WA
Back to AD 90-04-06 R1