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.
N7449YMiddle Georgia Aviation Inc · Cochran, GAN744AAtp Aircraft 6 LLC · Wilmington, DEN744ABBeverung Robert D · Manitowish Waters, WIN744AFCm3 LLC · North Las Vegas, NVN744AKExpress Helicopters LLC · Houston, TXN744BBCooper Roy · Lamesa, TXN744CJJersey Aviation LLC · East Orange, NJN744CPCivil Air Patrol · Maxwell Afb, ALN744CWSmith Shepard E · Los Angeles, CAN744DMMaloney Daniel D · East Amherst, NYN744DSShuey Jack L Jr · Owego, NYN744ESUsaircraft Inc · Newark, DEN744JAWiebe Albert · Seminole, TXN744JNAvia Flight Academy LLC · Stratford, CTN744KGLehmann Air LLC · Kerrville, TXN744MDeforest Shawn L · Lexington, NCN744MTChrisman Kenneth A · Spring, TXN744NDAir Shares LLC · Casper, WYN744PASkywest Leasing Inc · Saint George, UTN744RGJohnston Philip · Mountain Home, TXN744SGGimblin Robert Steven Trustee · Yuba City, CAN744TAAtp Aircraft 7 LLC · Wilmington, DEN744TWTumbleweed Leasing Co Inc · Salt Lake City, UTFirst renewal noticeN74500Lanier Equipment Leasing LLC · Gainesville, GAN74501Barnes Michael N · Lindstrom, MNN74502Land Dustin M · Bascom, FLN74505Registration Pending · Redlands, CARegistration pendingN74507Bas Part Sales LLC · Greeley, CON74508Agricultural Tours LLC · Cheyenne, WYN7450GLewis Benjamin · Delano, MNN7450JBuchanan David · Elkin, NCN7450KMatelski Mark T · New Berlin, WIN7450WCreager Scott L · Visalia, CAN74510Hood Joseph L · Ann Arbor, MIN74511A & D Wings LLC · Clarkston, MIN74513Munasinghe Chanaka · Portland, ORN74514Krupinski Floyd M · Chugiak, AKN74516Daniel Gary T · Athens, GAN74517Linstad Daniel E · Canby, ORFirst renewal noticeN7451JMoore Jimmy I · Beach City, TXN7451KHendry Joshua · Carthage, TNN7451WSamson Ag Flying LLC · Wilmington, DEN74522Blue Line Holding LLC · Little Falls, MNN74525Barnard Vaughn N III · Raleigh, NCN74527White Jesse J · Penn Valley, CAN74529Harris Nathan J · Preston, IDN7452JMcaleer John D · Molalla, ORN7452PTimothy A Cox · Coshocton, OHN74533Whalen Shenandoah · Amelia, OHN74535Rodgers Doyle W · Longview, TX
Back to AD 81-18-04 R2