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.
N65767Chu'S Sky LLC · Brandon, FLN6576BMoore Roger W · Poinciana, FLN6576JPa28 Nevada LLC · Incline Village, NVN65770Thompson Clinton J · Greer, SCN65772Sky Adventure LLC · Bartlett, TNN65773Ial Corp · Lewes, DEN65775Ristrim Eric · Henderson, NVN65776Meridian Aviation Holding Company · Teterboro, NJN6577HRegistered aircraftN6577JSpark Solar Power LLC · Chandler, AZN6577QForce Gary · Granbury, TXN6577RAir Echo Alpha 51 LLC · Erie, CON6577UKoehler Richard E · Port Orange, FLN6577WAdventist World Aviation · Wilson, NCFirst renewal noticeN65784Ohio State University · Columbus, OHN65789Burket George C · North Hollywood, CAN6578AAir Mods And Repair Inc · Robbinsville, NJN6578JMalone W Paul · Coulee City, WAN6578RGrinnell Herbert W · Oroville, CAN6578UJbl Aeronovia LLC · Kent, WAN6578WHanauer Keith A · Bloomfield, INN65790Horan Peter · North Easton, MAN65794Baker Curtiss L · Kinston, NCN65798Samons David M · Phoenix, AZN6579JBender Auto Body Inc · Middleville, MIN6579PDantas Ricardo J · Apple Valley, CAN6579URegistered aircraftN657CAOlson David A · New Underwood, SDN657CPCivil Air Patrol · Maxwell Afb, ALN657EREmbry-Riddle Aeronautical University · Prescott, AZN657MCPotts Robert G Jr · Oak Hill, FLN657MJRumiano Keith D · Vina, CAN657NDUniversity Of North Dakota · Grand Forks, NDN657RVHart Tom J · Aurora, ORN657SCKruse Shannon E · Republic, MON657SPChristiansen Aviation LLC · Wilmington, DEN657SRRm & Lp Ltd · Azalea, ORN657TBWilson Adrian H · Orange Park, FLN657TPZma LLC · North Little Rock, ARN6580JPoppy Wayne J · New London, WIN6580LHigh Wing Air Services LLC · Merritt Island, FLN6580WPanero Philip J · Merritt Island, FLN6581Dugas David J · Panama City, FLN65813Northwest Wings LLC · Hillsboro, ORN6581PPeavey Dayanna · Charles Town, WVN6581RMyrtle Beach Dustless Blasting Llp · Loris, SCN6581VSimmons Claude E · Ocracoke, NCN65821Goodley Scott Val · Denton, TXN6582RFca Flight Training And Aircraft Maintenance Inc · Wshngtn Ct Hs, OHN6582URing Zachary B · Moreno Valley, CA
Back to AD 81-18-04 R2