AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N3308SSutton Aircraft Salvage LLC · Palmer, AKN3308ZWeber Daniel Troy · Port Charlotte, FLN33092Shepherd Edward H · Grass Valley, CAN33095Kollmansberger James K · Fond Du Lac, WIN33096United States Air Force Owner · Offutt Afb, NEN3309CScott Parker H · Bulverde, TXN3309JMomentum Foundation · Tullahoma, TNN3309SCessna 210 N3309s LLC · Yellville, ARN3309XCabanas Alexis Santiago · Stroudsburg, PAN3309YRuschak Donald A · Charleroi, PAN3309ZRubbert Randy C · Reynolds, NDN330ARegistered aircraftN330ALDemuri Daniel J · Woods Cross, UTN330BDD & J Holdings LLC · Ellis, IDN330CAOsborn Richard H · Bakersfield, CAN330CDDec Enterprises LLC · Naples, FLN330CLCoalos Inc · State College, PANon-citizen corporation, flight hours not reportedN330CPCharlie Pop Flyers Inc · Jacksonville, FLN330CTRobinson Paul J · Saint Joseph, MON330DDUtah State University · Logan, UTN330DGAerospace Trust Management LLC Trustee · Wilmington, DEN330DJPrecision Aviation Specialty Services LLC · Bay Minette, ALN330DPAdvanced Commercial Group LLC · Helena, MTN330FSkydive Wayland LLC · Melbourne, FLN330FTSuwannee Arrow LLC · Clearwater, FLN330GBBrenner Gary L · Mission Viejo, CAN330HLSwift David A Trustee · Springfield, MON330HPBigman Elliot S · Todd, NCN330JDGreen Erik M · Mastic Beach, NYN330JGCultra LLC · Naples, FLN330KGBeats Driving LLC · Falling Waters, WVN330KRCherry Hill Aviation Inc · Freetown, INN330LSDawson Douglas · Fernley, NVN330MEUnique Educational Experiences · Signal Hill, CAN330MFWroblewski Peter Ross · Lompoc, CAN330MMHobbs Phillip E · Saint Augustine, FLN330MRJett Aviation LLC · Clovis, NMN330MSCanyon Airmotive LLC · Frisco, TXN330PCaldaso Inc · Peachtree City, GAN330PMPractical Education LLC · New York, NYN330RLBlue Mountain Flyers · Palmerton, PAN330RSSimeone Richard A · Rock Hill, SCN330SMSa Aerosports LLC · Kalispell, MTN330SXDb Aero Inc · Wilmington, DEN330TAAdvanced Aerobatics LLC · Ocala, FLN330TFMartin Earl · Seneca Falls, NYN330WH2k Partners LLC · Dallas, TXN330ZVinciguerra Wayne D · Sutter Creek, CAN33107Florida Coastal Flying Club LLC · Titusville, FLN3310DGrewe Mike · Lake In The Hills, IL
Back to AD 2007-04-19 R1