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.
N6647WPanama Truck Line LLC · Florissant, MON6648PAnkrom Lloyd Paul · Manasquan, NJN6649JBowline Ray D · Salina, OKN6649UKuykendall William · Yantis, TXN664AKWarren John · Homer, AKN664CAChristiansen Aviation LLC · Wilmington, DEN664CPTextron Aviation Inc · Wichita, KSN664EREmbry-Riddle Aeronautical University Inc · Prescott, AZN664FLElon Aviation LLC · Burlington, NCN664HBraddock Douglas S · Limestone, TNN664JFFarrell Jeremiah E · Burnsville, MNN664PBThomas Anthony Robert Jr · Frederick, MDN664SBRv Air LLC · Leander, TXN664TJEddleman John C · White Rock, NMN664WBilliar Michael E · Independence, ORN665Hamrick Gary L · Willshire, OHN6650JCarolian Aviation LLC · Bexley, OHN6650PAnderson Gregory · Acworth, GAN6650ULarson Reid A · Medford, MAN6650WCole Alexander G · Leander, TXN66512Capp Sam · Juneau, AKN6651RZucha Joseph P · Rio Vista, CAN6651UWilliams Jerry L · Cortez, CON6652GHenehan Brendan A · Geneva, NYN6652PKlapstein Nancy M · Sweet Grass, MTNon-citizen corporation, flight hours not reportedN6652WLumley John J · Delray Beach, FLN6653LDempsey Christopher S · Ponderay, IDN6653URevisky Veronica F · Minooka, ILN66545Mcclellion William R III · Anderson, SCN6654FRed River Aviators Flying Club · Bossier City, LAN6654HBertapelle Joseph R · Derby, KSN6654PBaldwin Gary S · Prescott, AZN6654UHarbison Aerospace LLC · Whites Creek, TNN6654WKosko Stanley G · Seattle, WAN6655HDonner Ronald W · Northfield, MNN6655JLaukkanen Heikki J · Camas, WAN6655PHensley George T · Telford, TNN6655UL & L Aviation LLC · Sidney, NEN6655W5b Aviation LLC · Duncan, OKN6656APike/Kelley LLC · Eureka Springs, ARN6656HCasey Thomas J · Fernandina, FLN6656JFauber Clifford W · Cincinnati, OHN6656PGregory James A · East Burke, VTN6656UFanselow Dan L · White Bear Lake, MNN6657JRegistration Pending · Tavares, FLRegistration pendingN6657PMiller Aaron M · Scottsdale, AZN6657WKlienstuber James D · Yamhill, ORN6658LChump LLC · Bridgman, MIN6658PParrish Troy Don · Tokio, TXN6659JDuffey Albert J · Clover, VA
Back to AD 81-18-04 R2