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.
N659DEEisenhauer Dwight · Lehighton, PAN659FLHudacko Daniel M · Saint Cloud, FLFirst renewal noticeN659FTFlorida Institute Of Technology Inc · Melbourne, FLN659GJHolmes Jonathan Charles · Mount Pleasant, SCN659HCHowlett Corey · Wasilla, AKN659KWWoods Kevin E · Albrightsville, PAN659MAStringham Charles A · Winnemucca, NVN659SPChristiansen Aviation LLC · Wilmington, DEN659TLLubonovic Thomas M · New Carlisle, OHN65ATRhodes Steven D · Anchorage, AKN65BJRamage Calvin L · Columbia, MON65BMVolatilis LLC · Wilmington, DEN65CDTeva Services LLC · Land O Lakes, FLN65CNJohnston Charles Wc Jr · Newfield, NJN65CWFranks Cory · Idalou, TXN65DEKilpatrick Blake E · Canyon Lake, TXN65DFAerospace Trust Management LLC Trustee · Wilmington, DEN65DHCrocker John M · El Dorado, CAN65DPPilawski Darren · Spring Hill, FLN65DRKlr Services LLC · Newalla, OKN65ECMartinez Fernando · Midland, TXN65EDConrad James J · Port Orange, FLN65EEEssler Kim L · Garrison, NDN65EJRobbins Lesley Linn · Bend, ORN65ELSutton Edwin · St Thomas, VIN65ESShaw Ellen M · Green Bay, WIN65FCColdpatrol LLC · Mount Pleasant, SCN65FDBarnstormer Leasing LLC · Murfreesboro, TNN65FTSkytypers Inc · Las Vegas, NVN65FVVyfvinkel Frederick J · New Smyrna Beach, FLN65GSchmitt Joseph P · Marshall, MON65GGRegistered aircraftN65GLDavidson Amber M · Cocoa, FLN65HFHorizon Flight Center LLC · Chesapeake, VAN65HPOhio Department Of Public Safety · Columbus, OHN65HRSt Squared LLC · Powell Butte, ORN65HTRoberts Bryan J · Norman, OKN65HYMarchant William A · Cleveland, GAN65JAJahawk Leasing LLC · Sugar Grove, ILN65JHJee Derrick W · Fort Walton Beach, FLN65JSCall One Inc · Clarinda, IAN65JTBlohm Jorge Tomas · Mooresville, NCN65JXFlight World Inc · San Juan, PRN65KCBarr Air Patrol LLC · Mesquite, TXN65KDNorthwest Wings LLC · Hillsboro, ORN65KFCrestwood Aviation LLC · Schererville, INN65KKExperimental N65kk LLC · Little Rock, ARN65MMShewbart Keith M · Crystal River, FLN65NCBarr Keith D · Reno, NVN65NPWilson Stuart L · Glenpool, OK
Back to AD 81-18-04 R2