AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-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:87-10-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:87-10-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:87-10-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 aircraftN713ECCharlie Tango LLC · Mechanicsville, VAN713EEHarper Larry · Marietta, GAN713EGRegistered aircraftN713GAMustang Sally Aviation LLC · Camden, SCN713HBB&B Aerosports LLC · Maryville, TNN713HMPinto Carlos · Tucson, AZN713HRMontana Department Of Fish Wildlife And Parks · Helena, MTN713HVRutan Aircraft Flying Experience · Waller, TXFirst renewal noticeN713JADesert Sealants Corp · Queen Creek, AZN713JHMccauley James · Ithaca, NYN713JKSbarounis Carl A · Torrance, CAN713JLJula James M · Portland, ORN713JPArizona Technical Construction LLC · Lake Havasu City, AZN713JRO Reilly Robert · Houston, TXN713LSMendel Joseph · Naperville, ILN713MMGannett Helicopters · Lander, WYN713MTSizemore John A · New Boston, NHN713NDUniversity Of North Dakota · Grand Forks, NDN713PMWestbank Fishing LLC · New Orleans, LAN713RBKay Timothy A · Kyle, TXN713REAks Aviation LLC · Arroyo Grande, CAN713SJKoerner James L Trustee · Gilbert, AZN713SQTransportation Solutions & Logistics Inc · Orlando, FLN713TBKasper Michael · Pahrump, NVN713VSJrr Professional Services LLC · Davie, FLN713WS&D Hangers · Galveston, TXN713WKLegends Air Center LLC · Bentonville, ARN713WTWtw Air LLC · Houston, TXN713XHenderson James Allen · Flomaton, ALN713ZHanten Michael A · Bremerton, WAN71409Piedmont Flight Inc · Winston Salem, NCN7140DRiedeman Thomas D · Genoa, OHN7140JCohesive Aviation LLC · Gilford, NHN7140LK Anthony Lax Aviation LLC · Mount Pleasant, SCN7140QMagnuson Jessica M · Olathe, KSN7140RJohnson Douglas W · Grand Forks, NDN7140TMurray Robert S Trustee · Shingle Springs, CAN7140VVallejo Noel R · Alpine, UTFirst renewal noticeN7140WDevers Malcolm W · Norwood, NCN7141BPatterson Brent E · East Aurora, NYN7141GDyke Paul A · Hartford, SDN7141LWamar Enterprises LLC · Eureka, MON7141PWild Aire LLC · Wilmington, DEN7141QFlight 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, NV
Back to AD 87-10-06 R1