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.
N7403PElliston Charles R · Brighton, CON7404KRegistration Pending · Eagle River, AKRegistration pendingN7404PWhisler Greg A · Lincoln, NEN7404RT&G Aviation Services LLC · Temple, TXN7404YSlowpoke Air LLC · Palm Harbor, FLN74051Plane Fun LLC · Valdosta, GAN74052Macdonald Mark A · Muskego, WIN74057Madden Patrick · Fort Lauderdale, FLN74058Ricci Anthony Albert · Bishop, GAN7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLN7405JMills Bailey J · Salem, ALN7405KPedersen Larry A · Waynesboro, PAN7405PClassic World Holdings LLC · Wilmington, DEN7405VBarrett Ronald A Jr · Shreveport, LAN7405WGo Fly Az LLC · Gilbert, AZN7405XWills Terry W · Cedar Park, TXN7406PAviation Collective LLC · Fort Worth, TXN7406VEvans Steven M · Somis, CAN7406YTucker Engineering Associates Inc · Locust, NCN74079Marques David A · Gilbert, AZN7407FFp Aircraft Holdings LLC · Alvord, TXN7407WTevik Michael A · Provo, UTN74080Lowry John O · Willis, TXN74086Meyer Michael · San Diego, CAFirst renewal noticeN74088Mcgee Neil R · Littleton, NCN7408DTobin John C · Olympia, WAN7408JHiller Alex T · Lake Orion, MIN7408KCapps Steven · Newcastle, OKN7408PJeffrey Thomas James · Crestwood, KYN7408RAdventures Aviation LLC · Whitehouse Station, NJN7408VM Twenty Inc · Bismarck, NDN74090Tiger Air LLC · Chatsworth, CAN74092Mcgill John G · Atlanta, GAN74094Eastern Shore Flying Service Inc · Wilmington, DEN74095Benson Edwin R · Gulfport, FLN74096Borden Lester N · Dalzell, ILN74099Sigg David · Bluffton, SCN7409DBartlett Donald R · Weirsdale, FLN7409GAero Quest LLC D/B/A · Olive Branch, MSN7409JAdp Consultants Inc · Laurel, MDN7409PPeters Gordon J · Salem, ORN7409ZFinger Lakes Soaring Club Inc · Dansville, NYFirst renewal noticeN740AMHawbaker Michael S · Warrenton, MON740CPCivil Air Patrol · Maxwell Afb, ALN740DAb Prop Plane II LLC · Metairie, LAN740HNBailey Roland L · Frazeysburg, OHN740HSSnook Harold F · Beaver Springs, PAN740NDUnd Aerospace Foundation · Grand Forks, NDN740PASkywest Leasing Inc · St George, UTN740RHUnited Helicopter Leasing LLC · Honolulu, HI
Back to AD 81-18-04 R2