AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N3443YTurner Nathan D · Nenana, AKN3444FAtwood David E Trustee · Nampa, IDN3444LDierick Greg E · Yakutat, AKN3444SBraha Thomas I · Mansfield, PAN3444ULepton Films LLC · Tarzana, CAN3445FAltus Aircraft LLC · Taylor, TXN3445LYama Air LLC · Granite Bay, CAN3445SBigfoot Aviation LLC · Shelton, WAN3446UTempus Morgan C · Cameron Park, CAN3446VPlane Fun Inc Tr Trustee · Snellville, GAN3447FEngh David Trustee · Wickenburg, AZN3447LHulst Damon M · Santa Barbara, CAN3447S182 Corp · Rockford, ILN3448FLarson Peter · Sheyenne, NDN3448RFour Eight Romeo LLC · Shallowater, TXN3448UHigh Planes Flyers Inc · Fort Collins, CON3448YMtdc LLC · Goddard, KSN3449FKunkel John A · Pine River, MNN3449RRobinson Timothy A · Casa Grande, AZN3449UHicks Brian Joseph · Shingle Springs, CAN3449YSteel Rock Aviation LLC · West Jordan, UTN344AJQualitair LLC Trustee · MichelstadtN344CACivil Air Patrol · Maxwell Afb, ALN344KLeblanc Debrah · Zachary, LAN344KVLutz Gregory J · East Bridgewater, MAN3450FPeeler Max H · Rock Port, MON3450VSchreiner Michael · Dallas, TXFirst renewal noticeN3451FBonnett Bruce J · Azle, TXN3451RBurkett Aerial Spraying · Coleman, TXN3451SChancellor Marvin E · Houston, TXN3451UJohnson Kevin S · Burns, ORN3451VPearman Aubum D · Tupelo, MSN3452DRault Jaimie E · Homer, AKN3452ROreagan Trenton David · Soldotna, AKN3452SWolff David Christian · Port Saint Lucie, FLN3452UNordland Tom Trustee · Boulder Junction, WIN3455FN3455f Aviation LLC · New Blaine, ARN3455SAcute Holdings LLC · Jenks, OKN3455UBown George Morgan · Shady Shores, TXN3455YKimmel James W · Fountain Hills, AZN3456UWright James R · Georgetown, CAN3456YGold Michael Benjamin · Frazier Park, CAN3457FStreet Jim A · Pilot Point, TXN3457SC Ville Flying Club · Nunica, MIN3457USelway Aviation Inc · Missoula, MTN3457VSchwab Coyle P · St Charles, ILN3458FAirport Lounge Mbi LLC · Dayton, OHN3458VEastern Stearman Inc Trustee · Leesburg, VAN3458YDelahunt David M · Simi Valley, CAN3459RRtd Aviation LLC · Hillsborough, NJ
Back to AD 84-10-01 R1