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.
N713DERegistered aircraftN713EGRegistered aircraftN713ETTello Edgar · Longisland, NCN713GAMustang Sally Aviation LLC · Camden, SCN713HVRutan Aircraft Flying Experience · Waller, TXFirst renewal noticeN713JADesert Sealants Corp · Queen Creek, AZN713JKSbarounis Carl A · Torrance, CAN713JLJula James M · Portland, ORN713JPArizona Technical Construction LLC · Lake Havasu City, AZN713LSMendel Joseph · Naperville, ILN713MMGannett Helicopters · Lander, WYN713NDUniversity Of North Dakota · Grand Forks, NDN713RBKay Timothy A · Kyle, TXN713REAks Aviation LLC · Arroyo Grande, CAN713SJKoerner James L Trustee · Gilbert, AZN713SQTransportation Solutions & Logistics Inc · Orlando, FLN713WKLegends Air Center LLC · Bentonville, ARN713WWPeters Gary B · Clarkston, WAN713XHenderson James Allen · Flomaton, ALN713ZHanten Michael A · Bremerton, WAN71404N457jh LLC · Meridian, IDN71409Piedmont Flight Inc · Winston Salem, NCN7140BEstep James B · Chillicothe, OHN7140DRiedeman Thomas D · Genoa, OHN7140JCohesive Aviation LLC · Gilford, NHN7140KChandelle Ltd · Brighton, CON7140LK Anthony Lax Aviation LLC · Mount Pleasant, SCN7140QMagnuson Jessica M · Olathe, KSN7140RJohnson Douglas W · Grand Forks, NDN7140VVallejo Noel R · Alpine, UTFirst renewal noticeN7140WDevers Malcolm W · Norwood, NCN7141BPatterson Brent E · East Aurora, NYN7141GDyke Paul A · Hartford, SDN7141LWamar Enterprises LLC · Eureka, MON7141QFlight Time Builders Inc · Memphis, TNN7141RAyars Dean P · Punta Gorda, FLN7141UBlazevic Bojan · Las Vegas, NVN7141WWest Richard R · Meridian, IDN7142DHarper Michael E · Cloquet, MNN7142FMarble Jere D · Dayton, NVN7142KHogan Mark C · Bend, ORN7142LEshuis Hermannus A · Lake City, FLN7142QObymachow Richard M · Killingworth, CTN7142UBykowsky Eric · Atlanta, GAN7142VTarantino Joseph A · Daytona Beach, FLN71431Klele John M · Midland, MIN7143FKnoth Kurt A · Grand Haven, MIN7143GAllen Nathanael W · Bemidji, MNN7143RWertz Travis F · Richland Center, WIN71444Rushville Flying Club Inc · Rushville, IL
Back to AD 90-04-06 R1