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.
N8156WLandis Michael D · Jonestown, PAN81577Juhl Wilbur D · Roundup, MTN8157CAfshar George · Trabuco Canyon, CAN8157MSpecialty Veterinary Services LLC · Monteverde, FLN8157NBolton Jeffrey · Mont Belvieu, TXN8157WFippin Brett Thomas · Brentwood, CAN8157YSchmidt Zachary P · Raleigh, NCN81586Elbarki Maged A · Boca Raton, FLN8158DBates James H · Lakeview, ORN8158NHorizon Aviation LLC · Brooks, GAN8158WMills Jeroldine C · Altaville, CAN8158ZLee Randy A · Gulf Shores, ALN81593Krueger Carl M · Kelleys Island, OHN815975 Niner 7 LLC · Fort Lauderdale, FLN8159AN8159a LLC · Jupiter, FLN8159KQ G Aviation Of America Inc · Fort Collins, CON8159PRegistration Pending · Tucson, AZRegistration pendingN8159WDowner Jesse S · Acampo, CAN815ATSeminole Aircraft LLC · Wilmington, DEN815CPCivil Air Patrol · Maxwell Afb, ALN815CTCoast Flight Training And Management Inc · San Diego, CAN815DFOglesby Richard A Jr · Atlanta, GAN815DKBas Part Sales LLC · Greeley, CON815DZBlue Sky LLC · Overland Park, KSN815EHBuell Travis · Harper, TXN815EREmbry-Riddle Aeronautical University · Daytona Beach, FLN815JHHeligroup LLC · Wilmington, DEN815JMMaling Jeff · Afton, WYN815KSPenner Bruce Wade · Hot Springs, SDN815KTFrase Kenneth E · Fall Creek, WIN815MM86aa LLC · Scottsdale, AZFirst renewal noticeN815PTTestory Perry E · Urbana, ILN815SGGierisch Frederick · Utopia, TXN815VPBarrett Jeff K · Pollock, LAN8160AKasw Aviation LLC · Warsaw, INN8160HRegistered aircraftN8160PSouth Texas Weather Modification Association · Pleasanton, TXN8160QAbaco Express Logistics LLC · Orlando, FLN81612Av8rlounge LLC · Columbia, SCN8161DDicey Aviation LLC · Somerset, KYN8161NKale Timothy E · Kailua Kona, HIN8161PSpringer Dennis J · Salem, ORN8161WPs Air Group LLC · Cape May, NJN8161XLittle Bluebird LLC · Tampa, FLN8162ADedominici Kenneth · East Bridgewater, MAN8162EMcmahan Steven C · Clay Center, KSN8162HPriest Peter J · Elk Grove, CAN8162QMcconnell Thomas R · St Simons Island, GAN8162RNoyes Daniel Ernest · Burton, MIN8162WBistline Fredrick G · Page, AZ
Back to AD 81-18-04 R2