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.
N5688WSerendipity Rentals LLC · Denver, CON56890Fink David J · Georgetown, TXN56898Evans Katrina · Watkinsville, GAN56899Mcdonald George · Inverness, FLN5689HChristie Ian A H · Limon, CON5689NRobinson Ryan A · Burbank, CAN5689PMarsala Joseph · Uxbridge, MAN5689QReynolds Shawn E · Ventura, CAN5689UGeorge Marc J · Harker Heights, TXN5689VStardust Aviation LLC · Farmingdale, NYN5689ZNichols Troy G · Clinton, ARN568BCN28179 Inc · West Gilgo Beach, NYN568CPCivil Air Patrol · Maxwell Afb, ALN568DDavid Glen E · Ash Fork, AZN568EParagon Flight Training Co · Fort Myers, FLN568FLAir Ventures Flying School LLC · Smithfield, RIN568GMSommersdorf Thomas G · Orlando, FLN568KAtp Aircraft 3 LLC · Wilmington, DEN568LTLuckie Mark O · Ashland, KSN568MCow Bell LLC · Sterling, AKN568MTMiddle Tennessee State University · Murfreesboro, TNN568NDAerosim Academy Inc · Sanford, FLN568RVNeumayer Barry A · Redlands, CAN568TRedfearn Todd D · Uvalde, TXN568WACarver Clarence K Trustee · Lutz, FLN568WFCruz Norman D · Las Vegas, NVN56900Roberts Marcus · Vancouver, WAN56902G R Martin & Associates LLC · West Plains, MON5690BK & L Aerial LLC · Echo, ORN5690DRolfe Cameron R · San Mateo, CAN5690HBackus-Flint Judith A · Blanchard, MIN5690KAircraft Guaranty Corp Trustee · Oklahoma City, OKN5690UPena Flight Partners LLC · Oakland, CAN56918Virgil Osvaido J · Glendale, AZN5691MBrowning Robert F · Washington, DCN5691PCoady Michael · Taylorville, ILN5692HHarma Michael J · Ironwood, MIN5692QOpen Air Aviation LLC · Colorado Springs, CON5692VI N K M & Associates Lllp · Columbia, MON5692WFollmer Harvey C III · Trout Run, PAN5692YSilverado Sales Inc · Orem, UTN56934Low Allen R · San Francisco, CAN56937Qualitair LLC Trustee · MichelstadtN5693HDorsay Edward R · Memphis, TNN5693PBays Aviation LLC · Boerne, TXN5693QKaufman Ben · Liberty, UTN5693SChupp David · Abbeville, SCN5693ZRustin Cody W · Reynolds, GAN56942Oracle Aviation LLC · Omaha, NEN56943Mcdowell David M · El Cajon, CA
Back to AD 81-18-04 R2