AD 81-11-02 R1
Registered aircraft · 1,752
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-11-02-R1')
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-11-02-R1')
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-11-02-R1') 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-11-02-R1') 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.
N22RNTre Ventures LLC · Mount Olive, NCN2308TBugarchich Christopher Z · Stratford, CTN2311TAlanair LLC · Red Hook, NYN2317TShirley Aviation LLC · Alexandria, VAN2325TFlorida State College At Jacksonville · Jacksonville, FLN2327TSale Reported · Hampton, GASale reportedN2328TElite Flight LLC · Lordstown, OHN2333TNottingham Jeffrey A · Locust Grove, GAN2334MSunrise Aviation Inc · Ormond Beach, FLN2336TN2336t Airplane Partnership LLC · Wilmington, DEN2339TK E F Enterprises Inc · Plymouth, MAN2340TGrillo Donald · Green Cove Springs, FLN2394MOld Buzzard Ltd · Columbus, OHN2436MVenture Aviation Inc · Arlington, MAN243DWSijtsma Wouter · Ladson, SCN245DWJr Aircraft LLC · Dayton, OHN2464QWilson Jeff · White Bluff, TNN246JBN246jb LLC · Boynton Beach, FLN2495MPark Brian D · Springville, UTN2496MMorgan Jay · Fort Mill, SCN24SWDann Mark A · Utica, OHN258SBSkyfusion II LLC · Atlanta, GAN2590QConant Edward · The Woodlands, TXN25ELPorcine Aviator LLC · Charlotte, NCN2601RHarden Aviation LLC · Washington, PAN2607RSullivan Christopher · Duson, LAN2610RStable Aviation LLC · Eagan, MNN261EZZokpodo Emmanuel K · Sacramento, CAN262XPrice Scott K · Sparks, MDN2634RRichardson Michael T · Inver Grove Hghts, MNN2672Q4m Aviation LLC · Orting, WAN2696RBowen Diane M · Newbury, MAN2697MCmp Aviation LLC · Williamsville, MON26JTBohning Aviation LLC · Ponchatoula, LAN2702RBas Part Sales LLC · Greeley, CON2703RWorthington Gary M · West Berlin, NJN2704RStratus Equity LLC · Helena, MTN2705RCenterline Aviation LLC · Nolensville, TNN2707RCsc Delaware Trust Co Trustee · Wilmington, DEN2712RSimply Living LLC · Fort Myers, FLN2719RJenkins Bruce D · New Market, MDN2722RPerez Angel L · Arecibo, PRN272LCPen And Pilot Inc · Flagler Beach, FLN2733RPatrick Barb · Farmer City, ILN2739RPerrong Andrew R · Huntingdon Valley, PAN2740RRegistration Pending · Wilmington, DERegistration pendingN2742RCollinsworth Frederick W · Broken Arrow, OKN2759RFord William(Bill) A III · Abilene, TXN276MGGeorgia Aviation Authority · Eastman, GAN2770RHayward Flight LLC · Hayward, CA
Back to AD 81-11-02 R1