AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6348AGzs Aviation LLC · Dover, DEN6348BXin Han Aviation LLC · Atwater, CAN6348JWingsleasing 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, OHN6349LFutrell Robert T · Pensacola, FLN6349MTakai Hiroyasu · San Jose, CAN634BWWoodard Brent · Whitefish, MTN634CPCivil Air Patrol · Maxwell Afb, ALN634CRChristiansen Aviation LLC · Wilmington, DEN634DPErvc Holdings LLC · Bumpass, VAN634FTNew Life Aviation LLC · Greeneville, TNN634GLVolar Xi LLC · Edmond, OKN634LLetourneau University · Longview, TXN634MMWutzke Jon R · Fargo, NDN634RSAugust Aero LLC · Kalispell, MTN634SJAmeriflyers 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, IDN6350MAirplanes And Helicopters Of Oregon LLC · Sisters, ORN6350NLynn Robert W · Independence, WVN6350PSinger Justin D · El Cajon, CAN6350QDavis Joseph T · Lunenburg, MAN6350RWebb Charles James · Freeport, NYN63512New England Aviation LLC · Plainville, CTN6351PAirplanes And Helicopters Of Oregon LLC · Sisters, ORN6351QRegistered aircraftN63521Santora Peter J III · Brooklyn, NYN6352LRegistered aircraftN6352NGilbreath Tony C DBA · Olustee, OKN6352PGassaway 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, TXN6353PMoore Byron · Elkhart, INN6353WHernandez Eliodoro · Wylie, TXN6354JNashville Cherokee Partners LLC · Hendersonville, TNN6354PCosentino William D · Lees Summit, MON6354QSibley Kevin W · Porter, TX
Back to AD 81-18-04 R2