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.
N8845KVan Bortel Aircraft Inc · Arlington, TXN88465Castleberry Inc · Ekalaka, MTN88467Atwood Christopher M · Brownsburg, INN8846CBranigan Leslie K · Amarillo, TXN8846JFighter Pilot Enterprises LLC · Eaton, CON8846LN8846l LLC · Homestead, FLN8846NDegener William L · Leonard, TXN8846PLecrone Gregory S · Granbury, TXN8846WMosby Eric M · Tallahassee, FLN88473A C E Aviation Inc · Ashton, IDN88476Bmg Aviation Inc · Bloomington, INN88477Holland William T III · Midway, ARN8847CBlumenberg Donald D · Fulton, SDN8847FNeitzer Robert W · Milwaukee, WIN8847JFlw LLC · Sandpoint, IDN8847MTravel Air LLC · Chico, CAN8847NMcdougal Thomas K · Woodward, OKN8847PSouth Texas Weather Modification Association · Pleasanton, TXN8847WCitro Michael A · Oakley, CAN8848CLeppert James J Trustee · Dickey, NDN8848JMegaw George C · Fort Lauderdale, FLN8848LSoaring Society Of Dayton Inc · Waynesville, OHN8848NPro Tech Aviation LLC · Corona, CAN8848WHocken David L · Avoca, IAN8848YBrunot Frank A · Spring Hill, FLN88497Airspace Aerial Media LLC · Saint Louis, MON8849CFitts David A · Salem, ORN8849JBailey Aviation Company LLC · Little Rock, ARN8849MGuertin Jim B DBA · Lincoln, CAN8849NCafran Lloyd V · Youngsville, NCN8849WAtchison Walter L · Los Alamos, NMN884ATDot Aviation LLC · Wilmington, DEN884BCBusiness Mens Flying Club Inc · Naperville, ILN884CAColeman Aero Club · Apo AeN884CPCivil Air Patrol · Maxwell Afb, ALN884DJohnson David L · Blaine, MNN884DCTanner Greg L · Bend, ORN884EFChudy Zbigniew P · Southington, CTN884EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN884FTFlorida Institute Of Technology · Melbourne, FLN884JSCrane John R · Niceville, FLN884MManning Michael · Bakersfield, CAN884MWWarfel Michael G · La Verne, CAN884PSSpainhower Paul Allex · Taylorsville, UTN884RVDannebrock Paul W · Lockport, NYN884SADamico Frank J · Pittsburgh, PAN884WGVandermay Brandon · Winnemucca, NVN8850NGregs Airplane Rental LLC · Eloy, AZN8851JMoore Jeffrey A · Lawrenceburg, TNN8851NBloodworth Nathan B · Hendersonville, TN
Back to AD 81-18-04 R2