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.
N2467CKsg Capital LLC · Casper, WYN2468FSky West Aviation Inc Trustee · Albuquerque, NMN2468JJh Investments LLC · Henderson, NVN2468WGodwin Gerald · Orange, TXN24693Anderson Mark D · Eureka Springs, ARN24696Lucas Charles W · Ladson, SCN24697Ritton Air Company LLC · Pittsburgh, PAN246ADBialas Robert E II · Fort Worth, TXN246AJJensen Alan · Rock Springs, WYN246AWSullivan Stanley D · South Jordan, UTN246AZRegistered aircraftN246BBTruman Nissley · Moberly, MON246CBCalifornia Baptist University · Riverside, CAN246CGDickerson Realty Corp · Charlotte, NCN246CPCivil Air Patrol · Maxwell Afb, ALN246FC69px LLC · Suttons Bay, MIN246JBN246jb LLC · Boynton Beach, FLN246JDHilliard Bruce · Grantsville, UTN246JKTobin Thomas · Sparks, NVN246JMForbes Thomas L · Poland, OHN246JSSullivan Jason W · North Pole, AKN246KKeeton James H · Atlanta, GAN246MEWyoming Seaplanes LLC · Alpine, WYN246NSilver Creek Aviation Services · Fort Worth, TXN246PKGeneva1 Aviation LLC · Mars, PAN246PMBesprozvanny Randy-Alexander R · San Marcos, CAN246RAJohnson Robert C · Dallas, TXN246RKFreeborn Mark Trustee · Phoenix, ORN246RLSwiss Eagles Inc · Las Vegas, NVN246SFAb Prop Plane I LLC · Metairie, LAN246SRFriendship Church · Frisco, TXN246SVN246sv Corp Trustee · Wilmington, DEN246TFMorgan Daniel D · Topeka, KSN246TMTango Mike Aviation LLC · Seneca Falls, NYN246TTTerry Timothy D · Gainesville, TXN246VABrascher Harry M · Spotsylvania, VAN246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNN247Bonewitz John A · Grapevine, TXN2470BAlpha International Aircraft Inc · Lewes, DEN2470FMeridian Aviation LLC · Lincolnton, NCN2470NAlpha International Aircraft Inc · Lewes, DENon-citizen corporation, flight hours not reportedN2470PFisher Air LLC · Cardington, OHN2471DWestern Edge Aviation LLC · Dickinson, NDN2471EWilliams Stephen H · Phoenix, AZN2471USchroeder Nyla R · Minneapolis, MNN2472UMustang Sally Aviation LLC · Camden, SCN2473GFly For Fun Aircraft LLC · Baltimore, MDN2473WCahill Chad · Edmond, OKN2473YFunderburg Erskine R · Pell City, ALN2473ZGulf Coast Aviation LLC · New Orleans, LA
Back to AD 2006-10-21