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.
N6941KWinter Gary L · Ocala, FLN6941NCaro Carlos H · Mcallen, TXN6941UBukac Glenn P · Villa Park, ILN6942Schwartz Kenneth G · Lincoln, CAN6942JAndromeda Air LLC · Houston, TXN6942KGold Cap LLC · Bremerton, WAN6942WBobbe Debra M · Paradise Valley, AZN6942YVan Fossen Eddie L · Bakersfield, CAN6943AOber John A · Candor, NYN6943BAndrews Joshua T · Lakeview, ORN6943KLow And Slow Aviation LLC · Williston, FLN6943NPhoenix Aviation Holdings LLC · Mesa, AZN6944CUpdraft Leasing LLC · Tea, SDN6944EHinds Archie L · Claremore, OKN6944JJhap LLC · Hubbard, OHN6944NYates Gary Douglas · Rose Hill, KSN6944WWerner Robert T · Blue Grass, IAN6945JK&B Properties LLC · Lexington, SCN6945NEveland Benjamin E · Henderson, NVN6945PBerg Alvin L · Overgaard, AZN6945QEllis Jordan Barrett · Oklahoma City, OKN6945UGipe Douglas A · Malvern, IAN6946CRegistration Pending · Fairbanks, AKRegistration pending, canceledN6946HPearson Kevin P · Dundee, ORN6946QBlalock James M · Sheridan, ARN6947BB&R Aerial Crop Care Inc · Connell, WAN6947NFlyfaraway Partners LLC · Sparta, NJN6947PHudzinski Joel David · Newaygo, MIN6947VGutierrez Juan · Sarasota, FLN6948KTerch Lawrence P Jr · North Pole, AKN6948NPeck Jeff · Denton, TXN6948PBernard David J · Paris, OHN6948WCraig Joshua G · Bonaire, GAN6949BPool Gene E · Anchorage, AKN6949KSaverio Gambassi · Bealeton, VAN6949NBanos Peter T · Coalinga, CAN6949PDepew Kevin I · Everett, WAN6949ULambert Donald H · Westwood, MAN6949VPaul Kevin A · Belgrade, MTN6949WSa Fliers LLC · Venice, FLN6949ZTide Water Soaring Society Inc · Windsor, VAN694ABGoldpick Dirtworx LLC · Wasilla, AKN694APCook Christopher W · Indian Mound, TNN694ARWilliams Robert R · Vernonia, ORN694BASlawko Paul A · Elverson, PAN694CPCivil Air Patrol · Maxwell Afb, ALN694CRBravo Zulu Aviation Services LLC · Jacksonville, FLN694DCSweet Dixie Aviation LLC · Reddick, FLN694JSHowell Renny P · Whitehouse, TXN694LHChristiansen Aviation LLC · Wilmington, DE
Back to AD 81-18-04 R2