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.
N722AARobinson Charles F Jr · Portage, MIN722AKInternational Air Services Inc Trustee · Carson City, NVN722BMButler Francis J · Fargo, NDN722CPFalcon 118 Denver LLC · Tiburon, CAN722CSBoccaccio Peter Anthony · Burke, SDN722DBColaur LLC · Nashotah, WIFirst renewal noticeN722DCHiemstra Andrew Ralph Walter · Tuolumne, CAN722DMU S Wire Manufacturers Inc · Redwood City, CAN722DSSav LLC · Shelton, WAN722EFEpic Aviation Inc · New Smyrna Beach, FLN722FLShaughnessy Thomas E · Seabrook, NHN722GTable For Seven Aviation LLC · Mountain Brk, ALN722GACougar Ga-7 LLC · Helena, MTN722HAPerformance Sanitation Of Mississip · Deland, FLN722JWMcintosh Kenneth V · Pleasant Plain, OHN722KJCraddock Kevin D · Clemson, SCN722KWBaker Scott · Chesterton, INN722LULiberty University Inc · Lynchburg, VAN722MAK2 Aviation LLC · Greenwood Village, CON722MBOmeara Clifton B · Broaddus, TXN722MCClassic Banjo LLC · Richmond, KYN722MWRegistered aircraftN722NDUnd Aerospace Foundation · Grand Forks, NDN722PGFuller Jon A · Goliad, TXN722RReady Aim Flyer LLC · New Castle, DEN722RATotal Prf LLC · Lewes, DEN722RHTb Aero Inc · Wilmington, DEN722RWRegistered aircraftN722SBWoodward James W · Sagle, IDN722SDGrove Bob · Boerne, TXN722SSWind Wizards Inc · El Paso, TXN722TIowa Aviation Heritage Museum · Ankeny, IAN722TBRettig Air LLC · Riverside, CAN722TCSchmitz William C · Charleston, SCN722WWeber Robert J · Manhattan, KSN722WMPegasus Enterprises LLC · Granbury, TXN7230FBenautics LLC · Wexford, PAN7230GMaples Kevin T · Pueblo, CON7230JBrewer Michael S · New Haven, WVN7230LLee Patrick G · Shawnee, KSN7230PFranks Orlan H III · Belton, TXN7230QArcade Flying Club Inc · El Dorado Hills, CAN7230YVyas Shiven P · Chino Hills, CAN7231JMcflight Aviation LLC · Highland, UTN7231KDengler Steven G · Lopez, WAN7231QDsr-Cherokee 180 LLC · Dallas, TXN7232CVector Aviation LLC · Mentor, OHN7232JEllero John L · Sun City, CAN7232POntiveros Vicente III · New Braunfels, TXN7232VSky Sailing Inc · Warner Springs, CA
Back to AD 81-18-04 R2