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.
N7707YLoveless John R Trustee · Bynum, TXN7708DR & R Hays Corp · Cody, WYN7708HJohnson Stephen C · Bonney Lake, WAN7708WCarter Veronica D · Mesa, AZN7709DAk8 Assets LLC · Talkeetna, AKN7709HNewberg Curtis G · Willmar, MNN7709JSkyborne Airline Academy Inc · Vero Beach, FLN7709NGallette John B · Edgewood, NMN7709WNewlin Thomas R · Montezuma, INFirst renewal noticeN7709YBauer Aviation LLC · Reese, MIN770AMKantorowicz Jon Carl · Great Falls, MTN770ASTyrrells Trails LLC · Fairbanks, AKN770BDJ/D Aviation LLC · Chisago City, MNFirst renewal noticeN770DHBetzen Ethan W · Wichita, KSN770DKStanton Michael · Wilmington, NCN770DTBargemann Jeffrey Karl · Greenville, OHN770DWHegg Timothy M · Cle Elum, WAN770FTThornton Spencer A · Patchogue, NYN770GCareer Pilot Training LLC · Wilmington, DEN770JLWirt David L · Bowling Green, OHN770NDN770nd LLC · Sidney, MTN770PRPuerto Rico International Airline Inc · Santurce, PRN770RPRipka James H · Grasonville, MDN770TCMyers Benny R · Wasilla, AKN770WHJacobson Luke W · Reno, NVN7710HStockmans Service & Supply LLC · Rushville, NEN7710KAtd Pilot Training LLC · Kansas City, MON7710MNavarre Curtis R · Chandler, AZN7710NSimpson Chad M · Dover, OHN7710WRegistered aircraftN7711Thomas Conrad H K · Lake City, FLN7711KVisser Paul C · Junction City, KSN7711PWhitewater Aviation Inc · Harrison, OHN7711WAmar James E · Goodyear, AZN7712HMiller Kevin T · Wasilla, AKN7712JChapman James A · San Antonio, TXN7712PLenbom Mark A · Cameron, WIN7713Jf Aerosports LLC · Vineland, NJN7713GDavenport Jimmy J · Hayesville, NCN7713KNottorf Eric W · Keller, TXN7713NSingh Harsimran · Las Vegas, NVN7713PFoster Mica J · Derby, KSN7713WBarber Mark E · Lighthouse Point, FLN7713YDarragh Jeff · Fort Myers, FLN7714CLuebow Jens · Madison, WIN7714DZapata James A · Fallbrook, CAN7714GGlynco Manning Aviation Inc · Brunswick, GAN7714WCrosswinds Flight Center Inc · Drums, PAN7714ZSimmons Aviation Services LLC · Pawcatuck, CTN7715Perry Damian E · Modesto, CAFirst renewal notice
Back to AD 81-18-04 R2