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.
N6549JHuff Glenn N · Hackettstown, NJFirst renewal noticeN6549ZRivers Larry R · Talkeetna, AKN654ACFlying Sparks LLC · Tomball, TXN654ALMoore Howard · Camden, TNN654BCCobb Charles J · Fallbrook, CAN654CRLinde Rodney C · Weatherford, TXN654CSCharlies Angel LLC · New Castle, DEN654EZN654ez LLC · Oyster Bay, NYN654FKimmel John · Milwaukie, ORN654FLRoca Roja Y Caballo Gris De Idaho LLC · Meridian, IDN654FTFlorida Institute Of Technology Inc · Melbourne, FLN654JFFreele James E · Rio Rancho, NMN654JWWilson Jared D · Midway, UTN654MRlw Wholesale LLC · Myrtle Beach, SCN654MLSmoking Hole Aviation LLC · Milford, NHN654NDInternational Air Services Inc Trustee · Carson City, NVN654NSElks Stephen A · Mountain City, TNN654PAPurdue Aviation LLC · West Lafayette, INN654PJPajak Paul J · Groveland, FLN654PTAnerv6a LLC · Minneapolis, MNN654PVHouston Traville S · Granbury, TXN654RTKonrad Melvin J · Cumming, IAN654RVVan Hoff Eric J · Gunter, TXN654SHHutcherson David R · Gretna, VAN654SPJm Air Holdings LLC · Stevensburg, VAN654WGlaeser Chris R · Plymouth, MNN654WMMillar Rick A · Anchorage, AKN654YRVet Air LLC · San Juan, PRN65501Right Rudder Arizona LLC · Litchfield Park, AZN65503Bentz Andreas · Falls Church, VAN65506Skelton James P Jr · Lithia Springs, GAN65507Cora & Associates LLC · Norcross, GAN6550JJans Stanley E · Dakota City, NEN6550PLux Kevin C · Vancouver, WAN6550UGeorge Ladelle L · Ashley, NDN65512Wiebe Van Michael · Filer, IDN65514Vogt Gregory A · Broken Arrow, OKN65516J-Airco LLC · Nashville, TNN65518Tk Equipment LLC · Brownsburg, INN6551LParker Kerry · Hobbs, NMN6551PWsv Aero Inc · Wilmington, DEN6551UAuker Donald · Lebanon, PAN6551WThull Stanley B · Freeport, MNN65525Sinha Nanda K · Benicia, CAN65528Jacks Charles D · Crowley, LAN6552BHollenberg Randall W · Houston, TXN6552FAir Planes LLC · Soddy Daisy, TNN6552JCherokee Flyers Inc · Phoenixville, PAN6552PSyc Holdings LLC · Missoula, MTN6552UGoldstein Meyer · Underwood, WA
Back to AD 81-18-04 R2