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.
N68475California In Nice Inc · San Jose, CAN68477Freiburger Thomas M · Belvedere, CAN6847BOtt Grosvenor LLC · Dillingham, AKN6847DPietron Spraying Inc · Larimore, NDN6847JMarkle Rick S · Waddy, KYN6847KWilson Galen B · Belchertown, MAN6847UFolkerts Thomas A · Roseville, CAN68485Dkg Cessna LLC · Flagler Beach, FLN6848BPainter William L · Salem, VAN6848JPrudent Paths LLC · Hillsborough, CAN6848NWinner William B · Durango, CON6848UKiefer Nathaniel Stephen · Del Rio, TXN68490Chersky Brian · Santa Maria, CAN68499Sheboygan Survey LLC · Waldo, WIN6849BWeeks Vaughan B · Racine, WIN6849JSecker David A · San Jose, CAFirst renewal noticeN6849NBig Bad Technology LLC · Hawthorne, FLN6849PSvenningsen Joshua J · Menomonie, WIN6849UShipman Terry · Flossmoor, ILN684APiper Archer Three LLC · Wilmington, DEN684ACMccabe Gurney G · Watertown, NYN684ATTexas Flight Training Aircraft 8 LLC · Wilmington, DEN684CPCivil Air Patrol · Maxwell Afb, ALN684DWSun Aircraft Management LLC · Ormond Beach, FLN684FLRegistration Pending · Odenton, MDRegistration pendingN684KWFour Kilo Whiskey LLC · Key West, FLN684LHChristiansen Aviation LLC · Wilmington, DEN684LVVassberg Eric · Aledo, TXN684NDUnd Aerospace Foundation · Grand Forks, NDN684RAArendale Richard O · Hattiesburg, MSN684RWWarren Randal W · Pine Bluff, ARN684SKShearer Gregory L · Avon, INN684SPCondor Aero Club Inc · Zelienople, PAN684TCPixel King 03 LLC · Fort Worth, TXN68500Air Dakota Flite Inc · Hettinger, NDN68504US Liberty Holdings LLC · Caldwell, IDN68505Volara Aviation LLC · Glendale, AZN68508Williams Houston · Minot, NDN68509Luvsflying Flight Training LLC · Staten Island, NYN6850ULarson Steven H · Angel Fire, NMN6850WDixon Holly R · Denton, NEN6850ZWagner Construction Inc · Intl Falls, MNN68511Urban Larry D · Conroe, TXN68512Ohio Aircraft Refinishing And Repair Inc · Edison, OHN68514Twin Cities Aviation Inc · Yuba City, CAN68515Gator Flight LLC · Saint Cloud, FLN68517Hanna Kirk · Portland, ORN68519King Michelle L · Atlanta, GAN6851ECharlie Lima 1 LLC · Jacksonville, FLN6851PPagano Glenn A · Rivervale, NJ
Back to AD 81-18-04 R2