AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1998RA & E Flying Club Of Los Angeles Inc · Hawthorne, CAN1999SVernon Margo L · Friendship, TNN1999TFly Boys Ink LLC · Ellington, CTFirst renewal noticeN1999YToth Thomas I · Federal Way, WAN199AMVeterinary Imaging Solutions Inc · Davis, CAN199BLSolera Aviation LLC · Bozeman, MTN199CACapital Holdings 109 LLC · Potomac, MDN199DHDunn James · Fair Oaks, CAN199DSIsland Wings Inc · Fort Lauderdale, FLN199ECRegistered aircraftN199GSHare Christopher W · Conroe, TXN199GWRaleigh Flying Club LLC · Chapel Hill, NCN199HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN199JFlight For Diabetes LLC · Richmond, ILN199JBOew Aviation LLC · Sumter, SCN199JTPena Rivera Luis A · Zephyrhills, FLN199LBL A B Flying Service Inc · Renton, WAN199MAEarles John F II · Bunkie, LAN199RAN199ra LLC · Huntington Woods, MIN199RGBell Aviation Inc · Wilmington, DEN199SBertrand William R · Lubbock, TXN199SAWin Win Aviation Inc · Wake Forest, NCN199SFMurphy Frank R · Canton, GAN199SPW Air LLC · Wheeling, ILN199STRandle Jan O · Lenoir, NCN199SWMcdonald Troy L · Morrison, CON199TAR-Bird LLC · Reno, NVN199TCStearns Nathaniel · Rochester, NYN199WBReinert Joseph Mason DBA · Chattanooga, TNN199XSugden Richard G · Wilson, WYN199ZSchweitzer Gregory M · Tabernacle, NJN19ACHannum Mark Edward · Woodland, CAN19ADRegistered aircraftN19BFKerkering Kenneth J · Colleyville, TXN19BROttopilot LLC · Lewes, DEN19BYPeralta Jose Ramon · Miami, FLN19BZStyer David B · Pendleton, ORN19CKBuckmeier Arlan M · Fairbanks, AKN19CWRussmann Nick S · Merit, TXN19DKRichardson Cotton Inc · Wilmington, DEN19EGGeorgia Forestry Commission · Macon, GAN19EWS & K Rentals Inc · Claymont, DEN19FCRegistered aircraftN19GJJmd Aviation LLC · Guilford, CTN19HCVista I Inc · Smithville, OHN19HJLogan Lonnie L · Grand Island, NEN19HPState Of Ohio Dept Of Public Safety · Columbus, OHN19HYGrqg Flyer LLC · Annandale, NJN19JBMcguire Michael D · Lake Stevens, WAN19JGImmeyer Daniel O · Redmond, WA
Back to AD 2006-10-21