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.
N9474VCasa Patrick Greg · Albuquerque, NMN9474WGoines Russel D · Highland, CAN9475DRoe Dennis N · Fairbanks, AKN9475EBerzinis Wayne T · Windham, MEN9475PGorin Eugene · Cedar Grove, NJN9475WGiese Aerial Inc · Hoffman, MNN9476FF & M Miya LLC · Hanford, CAN9476HHelicopter Partners Inc · Wellington, FLN9476JNery Thomas A · Mansfield, MAN9476NScheigert Delbert F Jr · Tucson, AZN9476PEdgar Montgomery Robert · Butler, PAN9477DJ H Miller & Son Inc · Saint John, WAN9477JMatthews Byron Kim · Hooper, UTN9477LSlipstream Aviation LLC · Carrollton, GAN9477VMurnville Glenlove Flyers Ltd · Delaware, OHN9477WBaker John E · Westfield Center, OHN9478NChadwick Aviation Services LLC · Monroe, CTN9478WAmerican Aircraft Sales LLC · Lincolnshire, ILN9479DGrote Neal Scott · Harrison, NEN9479WSchacher Daniel E · Muleshoe, TXN947MRonneburger Brian · Northport, NYN947TESkyway V LLC · Naples, FLN947TTPucciariello Alexander A · Punta Gorda, FLN9480CDave Gross Inc · Midland, TXN9480DKent State University · Stow, OHN9480EMoyer Aviation Inc · Tobyhanna, PAN9480HMoynihan Patrick J · Lakeville, MNN9480J217 Moriarty LLC · Stonewall, MSN9480PJmo LLC · Ridgeland, MSN9480RWestern Montana Orthopaedic LLC · Missoula, MTN9481DBoemig Madison K · Dalton, NHN9481JRuffner Samuel D · Powder Springs, GAN9481KHepp Investments LLC · Warrens, WIN9481NKing Cindy · Purvis, MSN9481PJeffcoat Cory D · Kountze, TXN9481VStutzman Mervin · Kingman, INN9481WMcintyre Stephen C · Lumberton, NCN9482CSchuetz Ray · Davie, FLN9482DHanley Company LLC · Littleton, CON9482PBurgar Charles G · Belton, TXN9482WCantrall Aviation Flying Club LLC · Elizabethtown, KYN9482ZChristiansen Aviation LLC · Wilmington, DEN9483CCnczilla Co · Royersford, PAN9483VScholls Arnold W · Syosset, NYN9483WFlying D Aviation Of Kansas LLC · Wichita, KSN9484HN9484h LLC · Wheeling, ILN9484KDoll Electric Co Inc · South Lake Tahoe, CAN9484NBourjeili Elias · Glendora, CAN9484PDavis Michael E Trustee · Brownsburg, INN9484VHannon Fredrick W · Punta Gorda, FL
Back to AD 87-10-06 R1