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.
N6345NColeman Darryl W · Fayetteville, GAN6345QPerry Edward Glen Trustee · Ozark, ARN6345VBas Part Sales LLC · Greeley, CON63461Georgia Golf Cars Inc · Douglas, GAN6346D6d Leasing LLC · Englewood, CON6346JSons Thomas · Norwood, MNN6346MElston Josh · Sterling, AKN6346RBuresh Noah A · Blair, WIN6346TNemec Jeffery W · Bowling Green, KYN6346VPierobon Luciano I · Port Orange, FLN6346WCottrill William M Jr · Joplin, MOFirst renewal noticeN63470University Of Central Missouri · Warrensburg, MON6347DAnthelion LLC · Flemington, NJN6347JGrove City Aviation LLC · Mercer, PAN6347PGear Down Hangar LLC · Phoenix, AZN6347TWang Peter Z · Germantown, MDN63482Hess Garrett J · Fullerton, CAN63483Eagle Sky Patrol Inc · Deadwood, SDN6348JWingsleasing LLC · Wichita, KSN6348NNelson Spraying Service Inc · Chester, MTN6348PRoddy Shannon B · Walker, LAN6348QMartin Chadwick P · Palm Harbor, FLN6348WMarquette County Flying Club Inc · Marquette, MIN6349Fox Christopher Kirk · Hanover, PAN6349CAmmons Gearey L · Marion, ARN6349DSprinkle Brent · Hillsboro, TXN6349GKuhns Mathew M · Saranac, MIN6349JH & H Aviation Enterprises LLC · Fairfield, OHN634CPCivil Air Patrol · Maxwell Afb, ALN634CTCorsair Aviation LLC · Yuba City, CAN634DPErvc Holdings LLC · Bumpass, VAN634FTNew Life Aviation LLC · Greeneville, TNN634MMWutzke Jon R · Fargo, NDN634SJAmeriflyers Of Texas Inc · Addison, TXN634TWDanley Arthur A Jr · Port Orange, FLN63503Criscenzo Philip A · Port Orange, FLN6350DMazza Salvatore M · West Creek, NJN6350JShort Final Aviation LLC · Twin Falls, IDN6350NLynn Robert W · Independence, WVN6350PSinger Justin D · El Cajon, CAN6350RWebb Charles James · Freeport, NYN63512New England Aviation LLC · Plainville, CTN6351QRegistered aircraftN63521Santora Peter J III · Brooklyn, NYN6352PGassaway Mitchell E · Carrollton, TXN6352SPutnam Gale L · Cape Fair, MON6352VMiles Richard A · Macon, NCN6352WYanak Larry E Jr · Perrysburg, OHN6353DDeland Aviation LLC · Deland, FLN6353MMont Belvieu Materials Inc · Mont Belvieu, TX
Back to AD 87-10-06 R1