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.
N9846PKenmore Crew Leasing Inc Trustee · Bellingham, WAN9846UFerrell Joseph R Jr · Christiansburg, VAN9846WVladimir Martyanov · Chandler, AZN98477Registered aircraftN9847GPilot In Command Academy · Miami, FLN9847LJoerithan & Mp Aviation LLC · Whittier, CAN9847PFell William P · Anchorage, AKN9847UIke Andrew · Twin City, GAN9847VWinder Editha S · Columbus, NMN9847WLukas Craig S · Omaha, NEN98485Amelia Reid Aviation LLC · San Jose, CAN9848CBudd Richard E · Brooksville, FLN9848GRicci Mark P · Waterford, MIN9848HBrekke Ryan S · Edmore, NDN9848JLanham David R · Visalia, CAN9848UHenley Jimmy · Linden, NCN9848VSuperhawk Flight LLC · Plano, TXN98492Henry Mark Alan · Dickinson, TXN98494Noggle William L · Warthen, GAN9849C377 Morale Welfare Recreational Services Aero Club · Albuquerque, NMN9849GPray Aviation Inc · Augusta, KSFirst renewal noticeN9849LDynasty Adventure Inc · Wilmington, DEN9849QBriggs Christopher T · Manchester, NHN9849UStaples L E · Granbury, TXN9849WKauenhofen Jacobo DBA · Boley, OKN984AUlrich Kenneth B · Mosinee, WIN984AVAtp Aircraft 1 LLC · Wilmington, DEN984BTMoore Aviation Inc · Beaver Falls, PAN984CPCivil Air Patrol Inc · Maxwell Afb, ALN984CTMorinaka Noble · Nyssa, ORN984FAFreedom Aviation Inc · Lynchburg, VAN984JAKinman Plumbing Co Inc · Louisville, KYN984JSFvx Research · Bristow, VAN984KEBulger Eric W · Peachtree City, GAN984PDLegends Air Center LLC · Bentonville, ARN984PLLightning Fast Aviation LLC · Helena, MTN984RSAnderson John C · Lake Geneva, WIN984SPRedstone Arsenal Flying Activity · Redstone Arsenal, ALN984SWWaits Paul C · Blanchard, OKN984THBadenhope John R · Greeneville, TNN984WBRichard Waldren LLC · Newberg, ORN984WUMoore Aviation Inc · Beaver Falls, PAN98502Sky Warrior Flight Training Inc · Pensacola, FLN9850UHagan Kenton Lee · Fayetteville, ARN9850VPropability One LLC · Daytona Beach, FLN9850WDestination Flyer LLC · Memphis, TNN9851CDodson International Parts Inc · Rantoul, KSN9851DSkarda Flying Service Inc · De Valls Bluff, ARN9851UPaul Brian K · San Angelo, TXN98525Trns Solutions LLC · Lewes, DE
Back to AD 81-18-04 R2