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.
N6905VOscar Mike Appraisal Group LLC · Greenville, SCN6905WPodeweltz Wayne L · Merrill, WIN6905ZZellers And Smith Enterprises LLC · Flowood, MSN69066Lake Elmo Aero LLC · Lake Elmo, MNN6906KWilliams Don D · Athens, ALN6906PKapeller James A · Wickenburg, AZFirst renewal noticeN6906QFlorida Keys Flight Academy LLC · Marathon, FLN6906VMatthews Cheryl L · Baker City, ORN6906WStandard American Adjusters Inc · Alba, TXN69078Central Texas College · Killeen, TXN6907BJordan Walter B · Chehalis, WAN6907NHensley Tyler · Leland, NCN6907PHolbein Mark A · Freeport, PAN6907VPounds Gregory S · Sykesville, MDN6908BMeriden Aviation Center LLC · Meriden, CTN6908KRegistration Pending · Dillingham, AKRegistration pendingN6908UPaul Michael · Fort Worth, TXN6908VForoozesh Paymon Michael · Olalla, WAN6909BKaufmann Arnold L · Davenport, IAN6909KJersey Devil Dusters LLC · Southampton, NJN6909NDevore John A C · Marion, OHN6909PWest Texas Weather Modification Association · San Angelo, TXN6909QHuston Lee E · Graham, WAN6909UVandivort Austin J · Strawberry Plains, TNN690ABKirkland Klayton E · College Station, TXN690BLincwings Society LLC · Austin, TXN690HAAims Community College · Greeley, CON690JTAviationmt LLC · Kalispell, MTN690LHChristiansen Aviation LLC · Wilmington, DEN690PMMiddlefield Farm And Garden Co · Middlefield, OHN690RGRegistration Pending · Gurabo, PRRegistration pendingN690SHCorriher Mark B · Mocksville, NCN690TSMartin Tony A · Kingwood, TXN690VBruegger Traylin T · Lance Creek, WYN690ZKalisz John B · Newhall, CAN691Rice James L · Mckinney, TXN69104Giger Janice F · Weston, ORN6910DWood Robert A · Sheboygan, WIN6910JPlane Nonsense Inc · Middletown, DEN6910NThornton Michael W · Clinton, NCN6910PBlue Skies Aviation LLC · Algona, IAN6910UEmbrey Quentin S · Beaver Dam, KYN6910VLehman Aubrey M · Temple, TXN69110Zumbrun Dennis · Montz, LAN6911HHarbour Aviation LLC · Weatherford, TXN6911JJacksonville Airport Authority · Jacksonville, ILN6911KHatley Sean P · Mount Horeb, WIN6911PMalo Blake Ridgway Trustee · Portland, ORN6911QKirby Richard L Trustee · Albuquerque, NMN69121Everett Rylan C · Broken Bow, NE
Back to AD 81-18-04 R2