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.
N6320CHeme Flying LLC · Lewisville, NCN6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLN6320JJns Corp · Wilmington, DEN6320QLucas Warr & White LLC · Florence, SCN6320RGehr Garner J · Eustis, FLN6321JPrecision Aircraft Service LLC · Staples, MNN6321MCalifornia In Nice Inc · San Jose, CAN6321PXin Han Aviation LLC · Atwater, CAN6321QDonesky Orville B · Cleveland, TNN6321TTwo One Tango LLC · Waynesboro, PAN6322JBaus Mark L · La Crosse, KSN6322LYoung Douglas Dale · Hopkinsville, KYN6322NThelander Edwin · Bristol, MEN6323Spence Vincent Anthony · Arlington, TNN6323JYoung Troy D · Vernon, TXN6323LSouth Bay International Flight Association Inc · Torrance, CAN6323NRay Raymond Heath · Louisville, KYN6323PJeffs Andrew S · Phoenix, AZN6323RSeigel Virginia L · Havre, MTN6323WMedicine By Design Inc · Miami, FLN6324DSmart Charles R · Verden, OKN6324HViele Mark C · Buckley, WAN6324NSimmons Rita B · Saint George, MEN6324PPorter John A · Cody, WYN6324QTymoshenko Yuriy · Clearwater, FLN6324TRegistered aircraftN6324VBranham Chris R · Anchorage, AKN6325DCox Ronnie L · Whitesburg, GAN6325JBantle Flyers LLC · North Chesterfield, VAN6325LStearns Edwin Ben Jr · Eloy, AZN6325RVaught Janet M · Creedmoor, NCN6326CBridges Gerald Lloyd · Chelsea, MIN6326EKevin Formica Inc · Boca Raton, FLN6326FAirtime Holdings LLC · Charleston, SCN6326QMontpelier Gary L · Bushnell, FLN6326RBlancett-Maddock David D · Kailua Kona, HIN6326WKipkurui Stephen · Fort Worth, TXN63273Hlavinka Terrance J · East Bernard, TXN63279P & H Air Inc · Overland Park, KSN6327PSunspot Investment Corp · Marathon, FLN6327QHarrod Tracey Lynn · Bedford, KYN6328JWildflower Remedies LLC · Millersburg, OHN6329JBeavers Danny G · San Antonio, TXN6329PKhan Adam Iqbal Ahmed · Sanger, TXN6329QRegistration Pending · Zavalla, TXRegistration pendingN6329RLomax Robert P · Belfair, WAN6329WKingsley Kaland W · Miller, MON632ACarroll Dana C · Wirtz, VAN632AAAerospring Leasing LLC · Wasilla, AKN632BGGoff Brad · Caldwell, ID
Back to AD 81-18-04 R2