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.
N56947Wings Of Hope · Chesterfield, MON5694AStyer David B · Pendleton, ORN5694HTischer William D · Shoreview, MNN5694UPlencner Robert E · Round Lake Beach, ILN5694WLange James R · Tempe, AZN56950Bodily Kent A · Washington, UTN56957Payne Glenn · Oregon, MON56958Jackson Michael L · Nixa, MOFirst renewal noticeN5695QBabb Douglas L · Telford, PAN5695W95whiskey LLC · Georgetown, MAN56964Lafollette Larry E · Strafford, MON56965Brazos River Aviation LLC · Plainview, TXN56966West David A · Astoria, ORN5696HVaughan William R IV · Benton, MSN5696MHubbard Benjamin L · Quogue, NYN5696QTrilogy Alliance Group LLC · Kearney, NEN5696WGiglio Tom J · South Boston, VAN56970Simoneau Todd · Sandown, NHN56972Eby Aviation LLC · Duluth, GAN56973Baja Flyers Inc · San Diego, CAN56976Tate Bird L Jr · Hammond, NYN56977Evans Holland L · Danielsville, GAN56978Brindley James G · Collinsville, ALN5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALN5697QReed Timothy W · Terrell, TXN5697ZLink James L · Raleigh, NCN56986Loya Armando · Whittier, CAN56987Ravotti Air LLC · Leechburg, PAN56988Hillerman Paul J · Vinita, OKN56989Kenny Zachary D · Herndon, VAN5698QCaughell David S · Bartlesville, OKN5698SNewell Gary A · Colmar, PAN5698UNorby David S · Gooding, IDN5698WBurkett Aviation LLC · Hampstead, NCN56991Schneider Stephen C · Denton, TXN56992Attebery Larry J · Caldwell, IDN569932c Fun Aviation LLC · Dallas, TXN56996Zarn Douglas J · Amboy, MNN56997Bibb John G · Paragould, ARN56999Lofty Images LLC · Owosso, MIN5699DClear Lake Management Corp · Wilmington, DEN5699HHalmans John D · Baker, MTN5699NStyer David B · Pendleton, ORN5699PHahn Curtis D · St George, UTN5699ULrh Equipment LLC · Pendleton, ORN5699VMesmer Robert F · Grand Island, NYN569BSZanetta Wayne T · Portland, ORN569CPCivil Air Patrol · Maxwell Afb, ALN569DPHale William J · Whitehouse, TXN569FGMustang Sally Aviation LLC · Camden, SC
Back to AD 81-18-04 R2