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.
N36TKKinsey & Co Inc · Las Vegas, NVN36TMPendragon LLC · Stuart, FLN36TNTornado Alley Turbo Inc · Ada, OKN36TRClark Tj · Saint George, UTN36VBRhc1 LLC · Myrtle Beach, SCN36VGMitchell Aviation LLC · Mitchell, SDN36VHSullivan John · Nashville, TNN36VKMp3 Aviation LLC · Nocona, TXN36VMTri-Rivers Enterprise · Cameron, MON36VTTurley Ty P · Ramona, CAN36VUThomas Gary F · Mount Shasta, CAN36WALandreth Kevin R · Ponca City, OKN36WBWhistle Britches LLC · Ardmore, OKN36WCBanos Joseph A · Saint George, UTN36WEMajor Holdings LLC · Lewes, DEN36WFLongboat Key Aviation LLC · Wooster, OHN36WYFlexible Flyer LLC · Cody, WYN36XArchangel Aviation LLC · Cleburne, TXN36XBSchmidt Thomas P · Nunica, MIN36XCHangar C-403 LLC · Walnut Creek, CAN36XGWhite Doug · Torrington, WYN36YBGrey Fox Corp · La Canada Flt, CAN36YMRankay Air LLC · Sanger, CAN36YPVillages Equipment Co · Leesburg, FLN36YSSlow Roll LLC · Gainesville, FLN36YVN36yv Holdco LLC · Mount Pleasant, SCN36ZNDawkins Christopher R · Trinity, NCN36ZQNorthern Flights LLC · Calumet, MIN370Bas Part Sales LLC · Greeley, CON3700KMathews Nancy M · Englewood, TNN3700TBrickner Gary K · North Highlands, CAN3700URydberg Lawrence · Albuquerque, NMN3701DN3701d LLC · Wilmington, NCN3701KCdm Atlanta Inc · Tyrone, GAN3701NGreat Lakes Aero Marine LLC · Green Bay, WIN3701PDibbell David L · South New Berlin, NYN3701RScarpelli Jim · Wichita, KSN3701TStewarts Aircraft Service Inc · Waynesville, OHN3701UBowley Steven Jon · Phoenix, AZN3701ZN3701z LLC · Athens, GAN3702FBuzjob Aviation LLC · Los Angeles, CAN3702POlson Ezra Ross · Kingman, KSFirst renewal noticeN3702QBonander Jeremy Ray · Tucson, AZN3702TDelp Thomas W · Rensselaerville, NYFirst renewal noticeN3702UCc Flyers LLC · Corpus Christi, TXN3703FPresby Aire LLC · Berlin, NHN3703PEvans Christopher W · Demotte, INN3703RAlexandria Flying Club Inc · Alexandria, MNN3703WGill James A · Gaithersburg, MDN3703XFortney Robert F · West Hollywood, CA
Back to AD 2007-04-19 R1