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.
N362SBNilco Enterprises Inc · Irving, TXN362SPEastern Cincinnati Aviation Inc · Batavia, OHN362TBarnett Blake C · Boynton Beach, FLN362WSBarrett Neville P E Trustee · Miami, FLN362ZKinder Jeffrey · Richland, WAN36304Capital Aviation II LLC · Bethesda, MDN3630NSalvesen William · Clermont, NJN3630QStar Aviation LLC · Mauston, WIN3630RLachance John A · Thompson, CTN3630WScarborough Robert T · Yuma, AZN3631CClark Mark R · Pullman, WAN3631DMortgage Experts LLC · Homestead, FLN3631EMudcat Construction Inc · Beattyville, KYN3631PRoss Donald M · Fallbrook, CAN3631UBurden Richard M · Woodway, TXN3631XLee Brent · Cumming, GAN3632APauly Adam · Macomb, MIN3632EHigh Exposure Inc · Wilmington, DEFirst renewal noticeN3632PAerospace Trust Management LLC Trustee · Wilmington, DEN36335Simmons Darren · Diamondhead, MSN36337Boling Derek · Paragould, ARN3633NPerotti Camille C · Carolina Beach, NCN3633RGrammar Adrian Gates · Geneva, NYN3633UBrasher Cecil V Jr · Jamestown, NCN3634RRatkovich Stephen · Prospect Heights, ILN3634WCarey Nicholas Isaac · Clarkston, WAN3634YKahn-Air LLC · Rumson, NJN36350Hennager Eric D · Langdon, NDN36351Mueller Michael A · Seguin, TXN36352Smith Steven Glen Trustee · Orem, UTN36355Nationwide Aviation LLC · Hudson Oaks, TXN36358Hans Aviation Inc · Davie, FLN3635ACaljet Inc · Van Nuys, CAN3635CMckinney Steve R · Hamersville, OHN3635QFantini Real Estate LLC · Louisville, KYN3635TFlorida Wings LLC · Wilmington, DEN3635WSwieter Avionics LLC · Waverly, IAN3635XInternational Air Charter Inc · Intl Falls, MNN3635YGo Mango LLC · Las Vegas, NVN3635ZRiggi Dean A · Scotia, NYN36361Smith Robert Ervin III · Mountain Top, PAN36362Sale Reported · WitshireSale reported, pending cancellationN36363Klein John · Woodland, CAN36364Gordon Security Solutions LLC · Chester Springs, PAN3636AScull Adam C · Hockessin, DEN3636CSale Reported · Galena, KSSale reportedN3636KCronin John M · Bremerton, WAN3636TFortier Stanley · Chico, CAN3636UVandeman Jack P · Norco, CAN3636WAltitude Aviation Services LLC · Mountain Home, ID
Back to AD 2007-04-19 R1