AD 48-08-01
Registered aircraft · 1,077
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:48-08-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-08-01')
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:48-08-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:48-08-01') 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.
N238SAzure II Flight Time LLC · Leesburg, FLN239VLomax John E · Powell, TNN23THLudlow Christopher C · Redding, CAN241HAMcfarland Mark C · Cottage Grove, ORN242JBMcgregor Todd R · Cincinnati, OHN250YMyers Mark E · Rogers, ARN251GT251gt Corp · Oak View, CAN252AALadson Timothy L · Savannah, GAN253JC96 Quick LLC · Wilmington, DEN262WPage Jeffrey Vernon · Washington, PAN2632PBargabos Richard O · Peterboro, NYN267CFBarks Kevin L · Dexter, MON270HBemenderfer Todd M · Mishawaka, INN2717VBlazek James T · Malta, ILN272AAEdj Aviation Limited · Fort Myers Beach, FLN273Lone Star Sorties LLC · Dickinson, TXN2736VHatloy Mark A · Drayton, NDN2751VGarrett Gregory Todd · Athens, TXN2754VSheldon Paul T · Saint James, MNN2762VJ R Bane Land Corp · Oakland, IAN2766VReady Aim Flyer LLC · New Castle, DEFirst renewal noticeN2768TNorth Wind Aviation LLC · Chelan, WAN2770THanson Leasing Inc · Bad Axe, MIN2772VCathcart Samuel H · Carlisle, OHN2778VPlane Fun Inc Tr Trustee · Snellville, GAN2785VGunnarsson Jon · Concrete, WAN2786VHoffner Edward M · Jefferson City, TNN2788THarnden Craig A · Lake City, FLN2795VBas Part Sales LLC · Greeley, CON2798VPorte Elvis · Miami, FLN27JCTalotta Nicholas J · Ocean City, NJN27THArizona Cloudbusters Inc · Mesa, AZN2804VPlumcrazy Aviation LLC · Ellenboro, NCN2813VAdair Edward A · Hemet, CAN2819VElgin Sky Snoopers Inc. · Crystal Lake, ILN2820VLundstedt Garry R · Fort Collins, CON2821VSchmitt Rudy · Brookshire, TXN2824VBigfoot Aviation LLC · Saint Michael, MNN2827TRegan Keith M · Torrance, CAN2834VKieper Mark A · Hampton, MNN2846VRegistration Pending · Shawnee, OKRegistration pendingN284AAFarwell William B · Benton, PAN2855VBunka Donald P · Fenton, MIN2858VMyers Alyssa L · Clayton, NMN285BWWatson Alex · Chadron, NEN2860VNord Aviation Inc · Pembina, NDN2861VBeck Roger M Trustee · Goode, VAN2868VBiehle Michael A · Yuba City, CAFirst renewal noticeN2870VSky West Aviation Inc Trustee · Albuquerque, NMN287JGGully John F · Brooklyn, NY
Back to AD 48-08-01