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.
N621KHMoody Aviation Management LLC · Forest, VAN621LPM2 Equipment LLC · Lubbock, TXN621LTWood Austin F · Seattle, WAN621MSAyagon Cecilia · Sequim, WAN621NDUnd Aerospace Foundation · Grand Forks, NDN621PAWings Over Texas Holdings LLC · Denton, TXN621PMAtp Aircraft 1 LLC · Wilmington, DEN621PWSkyten Flying Club Inc · Orefield, PAN621RBentley Aero Inc · Wilmington, DEN621TCsa Aircraft Leasing LLC · Salt Lake City, UTN621TGSchmotzer Donald S · Ladson, SCN621TKSheeptick LLC · Conrad, MTN621VBingham Lane M · Marble Falls, TXN622Chambliss Aerobatics LLC · Chandler, AZN62209Christiansen Aviation LLC · Wilmington, DEN6220UBarnes Dennis W · Saint Joseph, MON6220WPuls Timothy W · Plainfield, ILN6221BJulius Kaleb · Mesa, CON6221LBorge Michael J · Chandler, AZN6221PLicata Paul Z · Mexico, MON6221UScott Terry · Panama City, FLN6222HMortenson Lyle · Kennebec, SDN6222PPacheco Carlos Antonio · Yuma, AZN6222SClear Sky Aviation LLC · Lewis Center, OHN6223JVanderstoel Alex T · Waterford, CAN6223MJones Gary M · Chugiak, AKN6223UHernandez Acosta Rodrigo Alejandro · El Paso, TXN6223VAxis Aviation LLC · Bloomingdale, GAN6223YSeminole Flying & Soaring Inc · Clermont, FLFirst renewal noticeN62245Gabrieles Wings LLC · Oldwick, NJN6224JRrr Transportation LLC · Oneonta, ALN6224LJohnson Lucas · Pleasant Lake, MIN6224MJuillerat Alain · Higden, ARN6224PDattilio Joseph · Wasilla, AKN6224UConti Daniel · Leonardtown, MDN6225JWolf Ronald · Abbeville, LAN6225MTurner Christopher H · Eagle River, AKN6225PMcvey Charles D · Merritt Island, FLN6225RHartman Michael F · Montclair, CAN62269Ashcraft Matthew · Abbott, TXN6226JXigent Aviation Inc · Wilmington, DEN6226PHofstetter Fred M · Boerne, TXN6226WN6226w Inc · Solon, IAN62273Mundell Terry Trustee · Rosston, OKN6227LAbraham Joe C · Bristow, OKFirst renewal noticeN6227RMidwestern Soaring Assoc · Peculiar, MON6227TCarpenter Cattle Co Inc · Brewster, KSN6227UVan Tilborg Dale W · Abilene, TXN62281Christiansen Aviation LLC · Wilmington, DEN62286Soaring Dragon LLC · Sheridan, WY
Back to AD 81-18-04 R2