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.
N79ACTen G LLC · Waddell, AZN79ATLatronica Gary J · Orland Park, ILN79AVRegistered aircraftN79BACampbell Allen · Marietta, PAN79BCCoen Brady DBA · Wiley, CON79BXGerhard Richard L · Lakewood, WIN79CKKempin Christopher C · House Springs, MON79CPProvenzano Jeffrey M · Decatur, ALN79DLattanzi James A · Atco, NJN79DGStar Aerobatics LLC · Columbia City, INN79DTBell Scott A · Mc Alpin, FLN79EDKugel Vincent M · Port Orange, FLN79FBBeeman Charles F · Grant, FLN79FYManaj Aviation LLC · Wilmington, OHN79GBurke Robert · Pierre, SDN79GLJones Robert B · Fresno, CAN79GTSomerville Corby · Sequim, WAN79HKHughes Theodore · Maryville, TNN79HLIndiana Paging Network Inc · Laporte, INN79HSHenderson State University · Arkadelphia, ARN79HYBobcat Ag LLC · Wooster, ARN79JMSexton Scott · Kenai, AKN79JTCalifornia In Nice Inc · San Jose, CAN79LDTcb Aviation LLC · Evansville, INN79LHSeveryn John R · Livermore, CAN79LKGonzalez Leon · Pembroke Pines, FLN79MEElliott Enterprises Group LLC · Wilmington, DEN79MFSkyking Aviation Services LLC · Carson City, NVN79MGCastle Aviation Inc · North Canton, OHN79MJ79mj LLC · Mercer Island, WAN79MLAugust Aero LLC · Kalispell, MTN79MPMissouri State Highway Patrol · Jefferson City, MON79MRMarbes Daniel · De Pere, WIN79MSUaa International Inc · La Verne, CAN79NANorthampton Aeronautics Inc · Northampton, MAN79NCLiam Clerkin Inc · Wilmington, DEN79PAFlightgest Academy LLC · Morrisville, NCN79PBTurner Mark · Madison, MSN79PTWelch Ivo · Los Angeles, CAN79QBBaer Marcus R · Aubrey, TXN79RCathey Thomas G · Dallas, TXN79RARegistered aircraftN79RGLouisne Gonzales · East Windsor, NJN79RHNowling Daryl · Palm City, FLN79RMHannah Ricky D · Bakersfield, CAN79SHLundquist E Christopher · Hillsborough, CAN79SRSlater Geoffrey · Opelika, ALN79SSDave Faust Inc · Wellington, KSN79STAllevato Eugenio · Northridge, CAN79SXHumphrey David · Bethel, AK
Back to AD 87-10-06 R1