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.
N955JAAero Equities LLC · Ventura, CAN955JPHassan Sibte · Brooklyn, NYN955LCSewell Michael D DBA · Russellville, ALN955MATaylor Christopher B · Vacaville, CAN955MTMiddle Tennessee State University Aerospace · Murfreesboro, TNN955PTCappe Investment Group LLC · Homestead, FLN955RVBlessinger Christopher R · Lenore, IDN955SEmge Douglas W · Albertville, ALN955SCAb Prop Plane I LLC · Metairie, LAN955SKConcho Aviation LLC · Sterling City, TXN955SMCustom Concrete & Building LLC · Pleasantville, TNN955SPBarto Jerrel C · Kula, HIN955TMaynard Robert R · Inglewood, CARegistration revokedN955TTWhelan Carol · Suffield, CTN95606Hillsboro Aero Academy LLC · Hillsboro, ORN9560JAdams Carl J · Conroe, TXN9560MPontarolo Michael A Trustee · Pacific Grove, CAN9560PJetran LLC · Horseshoe Bay, TXN9560SMoore Justin W · Hollywood Park, TXN9560UBletsis Richard · Kokomo, INN9560VRegistration Pending · Big Spring, TXRegistration pendingN9560WGeneral Aviation LLC · Henderson, NVN95615Li LLC · Seattle, WAN9561CRak Flight Squad LLC · Bronx, NYN9561DHughey Randal P · Muskegon, MIN9561FBarrows Carl A · Lisle, NYN9561JScarlet Aviation LLC · Jonestown, PAN9561LWalter Terrance A · Pinckney, MIN9561MAck & Co LLC · East Helena, MTN9561VAbove And Beyond Aviation LLC · Austin, TXN95626Smith Charles · Hays, NCN9562BCharleston Flying Club LLC · Charleston, SCN9562HL & W Aircraft Investments LLC · Homestead, FLN9562JPosnett William L III · Lexington Park, MDN9562MPhillips Gary C · Midland, MIN9562PAvolant Aviation LLC · Mooresville, NCN9562QSilverhawk Aviation Academy Oregon LLC · Ontario, ORN9562SVon Bevern Brian J · Overland Park, KSN9562UFoote Peter S · Lockport, NYN9562VWinged Winds LLC · Douglassville, PAN9562WHub City Aviation Academy LLC · Lubbock, TXN9563Marzich Frank M · Rockford, ILN95639Barbee Donald · Columbus, OHN9563AChristiansen Aviation LLC · Wilmington, DEN9563FClunie David A · Bangor, PAN9563LFite James · Victorville, CAN9563PTodd Doug A · De Witt, IAN9563TStone Michael S · Chamois, MON9563UCrawford Aviation LLC · Richmond, VAN9563WEastside Development Co Inc · Winfield, KS
Back to AD 81-18-04 R2