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.
N881VAGraybird LLC · Scottsdale, AZN881WABlahut Robert John · Prosser, WAN88200Auer William E · Saint Petersburg, FLN88202Moore David J · Beechgrove, TNN8820CPfaff Kirk J · Jamul, CAN8820DMayo Jesse J · Fairbanks, AKN8820EDishman John David · Brooklyn, NYN8820JSurles Willian T · Chuckey, TNN88214Mcclanahan John B · Fayetteville, GAN88215George Gary D · Humble, TXN8821ERegistration Pending · Dothan, ALRegistration pendingN8821FRuhlman Dan C · Youngsville, PAN8821JJanssen Brittney Juen · Pleasantville, IAN8821LSouthern California Soaring Academy Inc · Valencia, CAN88223Mather Don A · Sandusky, OHN88225Horst Aviation LLC · New Holland, PAN88227Acadian Dusters LLC · Church Point, LAN8822CSeaton Carsten T · Fairbanks, AKN8822DWhite Glen A · Timber, ORN8822NFirestine Joseph W · Atwater, CAN8822PCornwell Charles E · Tucson, AZN88230Smithson Charles W · Wasilla, AKN88233Dupont Larry W · North Hero, VTN88237Bas Part Sales LLC · Greeley, CON8823CMcgee David · West Monroe, LAN8823FHudson Valley Helicopters Inc · Wilmington, DEFirst renewal noticeN8823JBas Part Sales LLC · Greeley, CON8823NAvia Flight Academy · Stratford, CTN8823PSite Solutions LLC · Bottineau, NDN8823WSpaulding Anthony Russell · Sonoma, CAN8823YFerrara John M · Newtown, PAN88241Walters Eugene H · Maupin, ORN88243Newbegin James T · Mc Alpin, FLN88245Steinle Michael · Lake Village, INN8824CRodriguez Carlos S · Poughkeepsie, NYN8824ECornelius John A · Fort Worth, TXN8824JJohnson Lawrence F · Ancorage, AKN8824NDale Keith Wayne · Gurdon, ARN88252Schell Joseph H · Granbury, TXN88256Greensted Richard E · Anchorage, AKN88258Ohlman Terry · Franktown, CON8825AGauges Green LLC · Euless, TXN8825JAlexander Carol E · Pineville, LAN8825NMissouri River Flying Club LLC · Mandan, NDN8825WSires Mark Steven · Lake City, FLN8825ZDisrud Roger G · Olathe, KSN88264Summers Philip A · Fairbanks, AKN88265Reiner Buck · Fishtail, MTN88266Kraxberger Rick R · Kasilof, AKN88268Neidert Melvin E · Ulysses, KS
Back to AD 81-18-04 R2