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.
N74561George James H · Punta Gorda, FLN74562Hamm Donald S · Carrollton, TXFirst renewal noticeN74564November Alpha LLC · Dover, DEN74565Shai Evan · Oak Bluffs, MAN74566Kerns Stanley M · Berryville, VAN74568Willis Charles D · Katy, TXN7456GGregory Larry C Trustee · Farmington, MON7456JSchwier Ronald G Jr · Bloomfield, NJN74571Mccurry Richard H · El Dorado, CAN74573Strout Adam Geoffrey · Manchester, MAN74574Burrell Helicopters LLC · D Hanis, TXN74576Varnes Mark R · Westminster, CAN74579Bethell A Ray · Heavener, OKFirst renewal noticeN7457JMoretti Stephen B · Cranston, RIN7457LPiper Lover LLC · Centennial, CON7457RFoster Adam W · Midland, TXN7457WNilsson Tim E · Yreka, CAN7457YPeter Prince Aviation Center LLC · Milton, FLN74581Lane Tyler R · Berthoud, CON74582Moo Nee LLC · Vero Beach, FLN74583Mile High Carpet Rides LLC · Dover, DEN74586Rainwater Farms LLC · Dover, DEN74587Curtis David W · Watertown, NYN7458DWheeler Evan L · North Pole, AKN7458JReeves Stephen · Watford City, NDN7458KMy Piper Pacer LLC · Everett, WAN7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN74590Registration Pending · Barry, TXRegistration pendingN74591Tiger Aero LLC · Beresford, SDN74592Higgs III Cyrus H · Jackson, TNN74593Sandlin Jesse L · Chesterfield, VAN74594Pinger Kevin R · Palo Alto, CAN74595Ehrhard Robert A · Jasper, INN74596Cato James W · Las Cruces, NMN74597Airman Helicopter Inc · Fort Lauderdale, FLN74599Fletchair Inc · Comfort, TXN7459JEvans Charles Dewayne · Cumby, TXN7459LStewart Martin J · Anchorage, AKN745CWKnight Verl D · Caldwell, IDN745FWWalther Frank C · Crawford, CON745GCHill Jack C · Arnold, MON745LMMurley Stephen L · Boerne, TXN745LSWeaver Chris D · Hallam, NEN745MSSchamel Michael A · Salem, INN745NDUnd Aerospace Foundation · Grand Forks, NDN745PASkywest Leasing Inc · St George, UTN745RAAri Ben Aviator Inc · Fort Pierce, FLN745SPBanks Douglas Trent III · Huntsville, ALN745TWTumbleweed Leasing Co Inc · Salt Lake City, UTN745ZZin Services LLC · Dover, DE
Back to AD 90-04-06 R1