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.
N9351JCoyote Flight Centers LLC · Amarillo, TXN9351LPiciullo Lenny R · Folsom, CAN9351MKempa Jesse R · Santa Cruz, CAN9351SHauling Ag Inc · Middlebury, INN9351TBenson Michael W · Julesburg, CON9351VCaldararu Andrei H · Madison, WIN9351WWurmbrand Stephan B · Westhampton, MAN93521Quitter John F · Galt, CAN93526Delta State University · Cleveland, MSN93529Richmor Aviation Inc · Hudson, NYN9352JDiorio Robert A · Redlands, CAN9352WNistler Anthony Lamar · Mcgregor, MNN9353DRegistration Pending · Simi Valley, CARegistration pending, canceledN9353JNychka Robert J · Wills Point, TXN9353MBarnett Zachary P · Paducah, KYN9353RStephanian Erick Trustee · Naples, FLFirst renewal noticeN9353VLangholz Denise M · Covington, WAN9354JLamb David S · Yuba City, CAN9354LElliott Brevyn · Marinette, WIN9354MFresh Air Properties LLC · Hayesville, NCN9354SLinda Ann Trust LLC · Dover, DEN9354VPinckney Robert L · Elgin, SCN9354WBlue Horizon Aircraft LLC · Wilmington, DEN93550Flight School Of Gwinnett Inc · Lawrenceville, GAN9355DHarris Chet A · Anchorage, AKN9355SBestway Pilot Car LLC DBA · Metropolis, ILN9355WEngland Noah C III · Lowell, NCN9356DHammond Dwight L · Burns, ORN9356HQuad Cities Aero LLC · Bettendorf, IAN9356JVali Air Service LLC · Livingston, MTN9356LCallaway Jonathan L · Van Alstyne, TXN9356MRegistered aircraftN9356RQuality By Design Inc · Leesburg, FLN9356SHeman Christopher M · Lees Summit, MON9356VWilson Willard L · Daphne, ALN9356WOrtman Stephen B · Mill Creek, WAN9357DLeary Patrick W DBA · Lewistown, MTN9357JKirchoff Jennifer L · Hamden, CTN9357MSpencer Jared · Mandeville, LAN9357PNewman Joseph G · Grand Ledge, MIN9357SWeiser Denis P · Osceola, IAN9357VWise Christopher J · Plano, TXN93585Sipher William M · Baker, FLN9358CMiloud Chadd K · Fort Worth, TXN9358ELechmanski Philip J · Shelter Island, NYN9358LUnited States Air Force · Eglin Afb, FLN9358SAnderson Justin T · Franklin, OHN9358TPitts Lynn Larry · Webb City, MON9358VEickman Jaret · Scottsdale, AZN9358WPena Evan M · San Antonio, TX
Back to AD 81-18-04 R2